VIEW: APPS.PAY_JP_SOE_RUN_YEA_V

Source

View Text - Preformatted

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')

View Text - HTML Formatted

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')