SELECT V1.ASSIGNMENT_ACTION_ID , NVL(V1.REPORTING_NAME , V1.ELEMENT_NAME) , V1.RUN_RESULT_ID , NVL(TO_NUMBER(PRRV.RESULT_VALUE) , 0) FROM PAY_RUN_RESULT_VALUES PRRV , HR_LOOKUPS HRL , PAY_INPUT_VALUES_F PIV , ( SELECT PAA.ASSIGNMENT_ACTION_ID , PPA.EFFECTIVE_DATE , PRR.RUN_RESULT_ID , PET.ELEMENT_TYPE_ID , PETTL.REPORTING_NAME , PETTL.ELEMENT_NAME FROM HR_JP_PARAMETERS HJP , PAY_ELEMENT_TYPES_F_TL PETTL , PAY_ELEMENT_TYPES_F PET , PAY_RUN_RESULTS PRR , PAY_PAYROLL_ACTIONS PPA , PAY_ASSIGNMENT_ACTIONS PAA WHERE PPA.PAYROLL_ACTION_ID=PAA.PAYROLL_ACTION_ID AND PRR.ASSIGNMENT_ACTION_ID=PAA.ASSIGNMENT_ACTION_ID AND PRR.STATUS IN ('P' , 'PA') AND PET.ELEMENT_TYPE_ID=PRR.ELEMENT_TYPE_ID AND PPA.EFFECTIVE_DATE BETWEEN PET.EFFECTIVE_START_DATE AND PET.EFFECTIVE_END_DATE AND PETTL.ELEMENT_TYPE_ID=PET.ELEMENT_TYPE_ID AND PETTL.LANGUAGE=USERENV('LANG') AND HJP.OWNER='PAYJPSOE' AND HJP.PARAMETER_VALUE=TO_CHAR(PET.CLASSIFICATION_ID) AND ( ( HJP.PARAMETER_NAME || '' IN ( 'SAL_SI_PREM_CLASS_ID' , 'SAL_SI_PREM_NONRES_CLASS_ID' , 'SAL_DEDUCT_CLASS_ID' , 'BON_SI_PREM_CLASS_ID' , 'BON_SI_PREM_NONRES_CLASS_ID' , 'BON_DEDUCT_CLASS_ID' , 'SP_BON_SI_PREM_CLASS_ID' , 'SP_BON_SI_PREM_NONRES_CLASS_ID' , 'SP_BON_DEDUCT_CLASS_ID' , 'TERM_DEDUCT_CLASS_ID') ) OR( HJP.PARAMETER_NAME = 'YEA_CLASS_ID' AND EXISTS( SELECT NULL FROM PAY_SUB_CLASSIFICATION_RULES_F SUB , HR_JP_PARAMETERS HJP2 WHERE HJP2.OWNER='PAYJPSOE' AND HJP2.PARAMETER_NAME='YEA_ITAX_DEDUCT_CLASS_ID' AND SUB.ELEMENT_TYPE_ID=PET.ELEMENT_TYPE_ID AND SUB.CLASSIFICATION_ID=TO_NUMBER(HJP2.PARAMETER_VALUE) AND PPA.EFFECTIVE_DATE BETWEEN SUB.EFFECTIVE_START_DATE AND SUB.EFFECTIVE_END_DATE) ) ) ) V1 WHERE PIV.ELEMENT_TYPE_ID(+)=V1.ELEMENT_TYPE_ID AND PIV.UOM='M' AND V1.EFFECTIVE_DATE BETWEEN PIV.EFFECTIVE_START_DATE AND PIV.EFFECTIVE_END_DATE AND HRL.LOOKUP_TYPE='NAME_TRANSLATIONS' AND UPPER(HRL.LOOKUP_CODE)='PAY VALUE' AND HRL.MEANING=PIV.NAME AND PRRV.RUN_RESULT_ID=NVL(V1.RUN_RESULT_ID , PIV.INPUT_VALUE_ID) AND PRRV.INPUT_VALUE_ID=PIV.INPUT_VALUE_ID