SELECT PAF.ROWID ROW_ID , PAF.ASSIGNMENT_ID , PBT.BALANCE_TYPE_ID , PBTTL.BALANCE_NAME , SES.EFFECTIVE_DATE FROM PAY_BALANCE_TYPES_TL PBTTL , PAY_BALANCE_TYPES PBT , PER_ASSIGNMENTS_F PAF , FND_SESSIONS SES , PAY_RUN_RESULT_VALUES PRRV , PAY_RUN_RESULTS PRR , PAY_BALANCE_FEEDS_F FEED , PAY_ASSIGNMENT_ACTIONS PAA2 , PAY_PAYROLL_ACTIONS PPA WHERE PBT.BALANCE_TYPE_ID = PBTTL.BALANCE_TYPE_ID AND PBTTL.LANGUAGE = USERENV('LANG') AND ((PBT.LEGISLATION_CODE IS NULL AND PBT.BUSINESS_GROUP_ID = PPA.BUSINESS_GROUP_ID) OR PBT.LEGISLATION_CODE = 'SG') AND SES.EFFECTIVE_DATE BETWEEN PAF.EFFECTIVE_START_DATE AND PAF.EFFECTIVE_END_DATE AND SES.SESSION_ID = USERENV('SESSIONID') AND PBT.BALANCE_TYPE_ID = FEED.BALANCE_TYPE_ID AND PRR.RUN_RESULT_ID = PRRV.RUN_RESULT_ID AND FEED.INPUT_VALUE_ID = PRRV.INPUT_VALUE_ID AND PRRV.RESULT_VALUE IS NOT NULL AND PRRV.RESULT_VALUE <> '0' AND PPA.PAYROLL_ACTION_ID = PAA2.PAYROLL_ACTION_ID AND PPA.EFFECTIVE_DATE <= SES.EFFECTIVE_DATE AND PAA2.ASSIGNMENT_ACTION_ID = PRR.ASSIGNMENT_ACTION_ID AND PAA2.ASSIGNMENT_ID = PAF.ASSIGNMENT_ID GROUP BY PAF.ROWID , PAF.ASSIGNMENT_ID , PBT.BALANCE_TYPE_ID , PBTTL.BALANCE_NAME , SES.EFFECTIVE_DATE