M.LOAN_PRODUCT, R.QUESTION_CATEGORY, COUNT(*) CNT FROM AUDIT_SAMPLE_MASTER M, AUDIT_QUEST_RESPONSE R, COMPLIANCE_MASTER C WHERE M.BRANCH IN ('201') AND TRUNC(M.SAMPLE_MONTH) IN ('01-JAN-2013') AND R.AUDIT_MASTER_SR_NO = M.SR_NO AND C.SECTION = R.SECTION AND C.QUESTION_NO = R.QUESTION_NO AND C.ANS = R.AUDITOR_ANSWER AND NVL(C.QUESTION_CAPACITY,'A')=NVL(R.CUST_CAPACITY,'A') AND C.VERSION = 2 AND NVL(C.SUB_ANS, 'A') = NVL(PKG_AUDIT_NEW.F_GETSUBANS(R.SR_NO), 'A') GROUP BY R.AUDITOR_REMARKS, M.BRANCH, C.PROCESS, C.STATUS, M.LOAN_PRODUCT, R.QUESTION, R.AUDITOR_ANSWER, R.SR_NO, M.SERVICE_CENTRE, M.SAMPLE_MONTH, M.FILE_NO, R.QUESTION_CATEGORY;