SELECT PAA.ASSIGNMENT_ACTION_ID , NVL(PETTL.REPORTING_NAME , PETTL.ELEMENT_NAME) , PBF.SCALE , PRR.RUN_RESULT_ID , NVL(TO_NUMBER(PRRV.RESULT_VALUE) , 0) FROM PAY_ELEMENT_TYPES_F_TL PETTL , PAY_BALANCE_TYPES PBT , PAY_BALANCE_FEEDS_F PBF , PAY_RUN_RESULT_VALUES PRRV , PAY_RUN_RESULTS PRR , PAY_PAYROLL_ACTIONS PPA2 , PAY_ASSIGNMENT_ACTIONS PAA2 , PAY_ACTION_INTERLOCKS PAI , PAY_ASSIGNMENT_ACTIONS PAA WHERE PAI.LOCKING_ACTION_ID=PAA.ASSIGNMENT_ACTION_ID AND PAA2.ASSIGNMENT_ACTION_ID=PAI.LOCKED_ACTION_ID AND PPA2.PAYROLL_ACTION_ID=PAA2.PAYROLL_ACTION_ID AND PRR.ASSIGNMENT_ACTION_ID=PAA2.ASSIGNMENT_ACTION_ID AND PRR.STATUS IN ('P' , 'PA') AND PRRV.RUN_RESULT_ID=PRR.RUN_RESULT_ID AND PBF.INPUT_VALUE_ID=PRRV.INPUT_VALUE_ID AND PPA2.EFFECTIVE_DATE BETWEEN PBF.EFFECTIVE_START_DATE AND PBF.EFFECTIVE_END_DATE AND PBT.BALANCE_TYPE_ID=PBF.BALANCE_TYPE_ID AND PBT.ASSIGNMENT_REMUNERATION_FLAG='Y' AND PETTL.ELEMENT_TYPE_ID=PRR.ELEMENT_TYPE_ID AND PETTL.LANGUAGE=USERENV('LANG')