SELECT PAF.ROWID ROW_ID , PAA.ASSIGNMENT_ID , PAA.ACTION_SEQUENCE , PBT.BALANCE_TYPE_ID , PAA.ASSIGNMENT_ACTION_ID , PBTTL.BALANCE_NAME , PDB.DEFINED_BALANCE_ID , PBD.DATABASE_ITEM_SUFFIX , PAY_SG_EXC.CALCULATED_VALUE(PDB.DEFINED_BALANCE_ID , PAA.ASSIGNMENT_ACTION_ID , PAA.TAX_UNIT_ID , SES.EFFECTIVE_DATE) VALUE , PAA.TAX_UNIT_ID , PPA.EFFECTIVE_DATE , PAY_SG_EXC.GET_EXPIRY_DATE(PDB.DEFINED_BALANCE_ID , PAA.ASSIGNMENT_ACTION_ID) EXPIRY_DATE , SES.EFFECTIVE_DATE SESSION_DATE FROM PER_ASSIGNMENTS_F PAF , PAY_PAYROLL_ACTIONS PPA , PAY_BALANCE_TYPES PBT , PAY_BALANCE_TYPES_TL PBTTL , PAY_BALANCE_DIMENSIONS PBD , PAY_DEFINED_BALANCES PDB , PAY_ASSIGNMENT_ACTIONS PAA , FND_SESSIONS SES WHERE ((PBT.LEGISLATION_CODE IS NULL AND PBT.BUSINESS_GROUP_ID = PPA.BUSINESS_GROUP_ID) OR PBT.LEGISLATION_CODE = 'SG') AND PAF.ASSIGNMENT_ID = PAA.ASSIGNMENT_ID AND PBT.BALANCE_TYPE_ID = PBTTL.BALANCE_TYPE_ID AND PBTTL.LANGUAGE = USERENV('LANG') AND SES.SESSION_ID = USERENV('SESSIONID') AND SES.EFFECTIVE_DATE BETWEEN PAF.EFFECTIVE_START_DATE AND PAF.EFFECTIVE_END_DATE AND PAA.PAYROLL_ACTION_ID = PPA.PAYROLL_ACTION_ID AND PDB.BALANCE_TYPE_ID = PBT.BALANCE_TYPE_ID AND PDB.BALANCE_DIMENSION_ID = PBD.BALANCE_DIMENSION_ID AND NOT EXISTS (SELECT '' FROM FF_ROUTE_CONTEXT_USAGES FRCU , FF_CONTEXTS FC WHERE FRCU.ROUTE_ID = PBD.ROUTE_ID AND FC.CONTEXT_ID = FRCU.CONTEXT_ID AND FC.CONTEXT_NAME NOT IN ('TAX_UNIT_ID' , 'ASSIGNMENT_ACTION_ID') AND NOT EXISTS (SELECT '' FROM PAY_ACTION_CONTEXTS PAC WHERE PAC.ASSIGNMENT_ACTION_ID = PAA.ASSIGNMENT_ACTION_ID AND PAC.CONTEXT_ID = FRCU.CONTEXT_ID)) AND EXISTS (SELECT '' FROM PAY_BALANCE_FEEDS_F PBF , PAY_RUN_RESULT_VALUES PRRV , PAY_RUN_RESULTS PRR WHERE PRR.ASSIGNMENT_ACTION_ID = PAA.ASSIGNMENT_ACTION_ID AND PRR.RUN_RESULT_ID = PRRV.RUN_RESULT_ID AND PRRV.INPUT_VALUE_ID = PBF.INPUT_VALUE_ID AND PBF.BALANCE_TYPE_ID = PBT.BALANCE_TYPE_ID AND PPA.EFFECTIVE_DATE BETWEEN PBF.EFFECTIVE_START_DATE AND PBF.EFFECTIVE_END_DATE)