SELECT PAF.ROWID ROW_ID , PAF.ASSIGNMENT_ID , PBT.BALANCE_TYPE_ID , PBT.BALANCE_NAME , SES.EFFECTIVE_DATE FROM PAY_BALANCE_TYPES PBT , PAY_BALANCE_FEEDS_F FEED , PAY_RUN_RESULT_VALUES PRRV , PAY_RUN_RESULTS PRR , PAY_PAYROLL_ACTIONS PPA , PAY_ASSIGNMENT_ACTIONS PAA , PER_ALL_ASSIGNMENTS_F PAF , FND_SESSIONS SES WHERE SES.SESSION_ID = USERENV('SESSIONID') AND SES.EFFECTIVE_DATE BETWEEN PAF.EFFECTIVE_START_DATE AND PAF.EFFECTIVE_END_DATE AND PAA.ASSIGNMENT_ID = PAF.ASSIGNMENT_ID AND PAA.ACTION_STATUS = 'C' AND PPA.PAYROLL_ACTION_ID = PAA.PAYROLL_ACTION_ID AND PPA.EFFECTIVE_DATE <= SES.EFFECTIVE_DATE AND PRR.ASSIGNMENT_ACTION_ID = PAA.ASSIGNMENT_ACTION_ID AND PRRV.RUN_RESULT_ID = PRR.RUN_RESULT_ID AND FEED.INPUT_VALUE_ID = PRRV.INPUT_VALUE_ID AND PPA.EFFECTIVE_DATE BETWEEN FEED.EFFECTIVE_START_DATE AND FEED.EFFECTIVE_END_DATE AND PBT.BALANCE_TYPE_ID = FEED.BALANCE_TYPE_ID AND NVL(PBT.LEGISLATION_CODE , 'JP') = 'JP' GROUP BY PAF.ROWID , PAF.ASSIGNMENT_ID , PBT.BALANCE_TYPE_ID , PBT.BALANCE_NAME , SES.EFFECTIVE_DATE