SELECT PAA.ASSIGNMENT_ACTION_ID , PRR.RUN_RESULT_ID , PIV.INPUT_VALUE_ID , DECODE(PIVTL.NAME , HRL.MEANING , NVL(PETTL.REPORTING_NAME , PETTL.ELEMENT_NAME) , PIVTL.NAME) , DECODE(PIVTL.NAME , HRL.MEANING , NULL , PIV.DISPLAY_SEQUENCE) , NVL(TO_NUMBER(PRRV.RESULT_VALUE) , 0) FROM PAY_ELEMENT_TYPES_F_TL PETTL , PAY_RUN_RESULT_VALUES PRRV , PAY_INPUT_VALUES_F_TL PIVTL , PAY_INPUT_VALUES_F PIV , PAY_RUN_RESULTS PRR , HR_JP_PARAMETERS HJP , PAY_PAYROLL_ACTIONS PPA , PAY_ASSIGNMENT_ACTIONS PAA , HR_LOOKUPS HRL WHERE HRL.LOOKUP_TYPE='NAME_TRANSLATIONS' AND HRL.LOOKUP_CODE = 'PAY VALUE' AND PPA.PAYROLL_ACTION_ID=PAA.PAYROLL_ACTION_ID AND HJP.OWNER='PAYJPSOE' AND HJP.PARAMETER_NAME='YEA_CLASS_ID' AND PRR.ASSIGNMENT_ACTION_ID=PAA.ASSIGNMENT_ACTION_ID AND PRR.ELEMENT_TYPE_ID=TO_NUMBER(HJP.PARAMETER_VALUE) AND PRR.STATUS IN ('P' , 'PA') AND PIV.ELEMENT_TYPE_ID=PRR.ELEMENT_TYPE_ID AND PIV.NAME=HRL.MEANING AND PIV.UOM='M' AND PPA.EFFECTIVE_DATE BETWEEN PIV.EFFECTIVE_START_DATE AND PIV.EFFECTIVE_END_DATE AND PIVTL.INPUT_VALUE_ID=PIV.INPUT_VALUE_ID AND PIVTL.LANGUAGE=USERENV('LANG') AND PRRV.RUN_RESULT_ID=PRR.RUN_RESULT_ID AND PRRV.INPUT_VALUE_ID=PIV.INPUT_VALUE_ID AND PETTL.ELEMENT_TYPE_ID=PIV.ELEMENT_TYPE_ID AND PETTL.LANGUAGE=USERENV('LANG')