VIEW: APPS.PAY_JP_SOE_RUN_DEPENDENTS_V

Source

View Text - Preformatted

SELECT paa.assignment_action_id, prr.run_result_id, piv.input_value_id, pivtl.name, piv.display_sequence, prrv.result_value, substrb(decode(piv.lookup_type,NULL,prrv.result_value,hr_general.decode_lookup(piv.lookup_type,prrv.result_value)),1,80) from pay_input_values_f_tl pivtl, pay_input_values_f piv, pay_run_result_values prrv, pay_run_results prr, hr_jp_parameters hjp, pay_payroll_actions ppa, pay_assignment_actions paa where ppa.payroll_action_id=paa.payroll_action_id and hjp.owner='PAYJPSOE' and hjp.parameter_name || '' in ( 'SAL_DEPENDS_ELM_ID', 'BON_DEPENDS_ELM_ID', 'SP_BON_DEPENDS_ELM_ID', 'YEA_DEPENDS_ELM_ID') and prr.assignment_action_id=nvl(paa.assignment_action_id,to_number(hjp.parameter_value)) and prr.element_type_id=to_number(hjp.parameter_value) and prr.status in ('P','PA') and prrv.run_result_id=prr.run_result_id and piv.input_value_id=prrv.input_value_id and ppa.effective_date between piv.effective_start_date and piv.effective_end_date and piv.uom <> 'M' and piv.lookup_type <> 'JP_ITAX_TYPE' and pivtl.input_value_id=piv.input_value_id and pivtl.language=userenv('LANG')

View Text - HTML Formatted

SELECT PAA.ASSIGNMENT_ACTION_ID
, PRR.RUN_RESULT_ID
, PIV.INPUT_VALUE_ID
, PIVTL.NAME
, PIV.DISPLAY_SEQUENCE
, PRRV.RESULT_VALUE
, SUBSTRB(DECODE(PIV.LOOKUP_TYPE
, NULL
, PRRV.RESULT_VALUE
, HR_GENERAL.DECODE_LOOKUP(PIV.LOOKUP_TYPE
, PRRV.RESULT_VALUE))
, 1
, 80)
FROM PAY_INPUT_VALUES_F_TL PIVTL
, PAY_INPUT_VALUES_F PIV
, PAY_RUN_RESULT_VALUES PRRV
, PAY_RUN_RESULTS PRR
, HR_JP_PARAMETERS HJP
, PAY_PAYROLL_ACTIONS PPA
, PAY_ASSIGNMENT_ACTIONS PAA
WHERE PPA.PAYROLL_ACTION_ID=PAA.PAYROLL_ACTION_ID
AND HJP.OWNER='PAYJPSOE'
AND HJP.PARAMETER_NAME || '' IN ( 'SAL_DEPENDS_ELM_ID'
, 'BON_DEPENDS_ELM_ID'
, 'SP_BON_DEPENDS_ELM_ID'
, 'YEA_DEPENDS_ELM_ID')
AND PRR.ASSIGNMENT_ACTION_ID=NVL(PAA.ASSIGNMENT_ACTION_ID
, TO_NUMBER(HJP.PARAMETER_VALUE))
AND PRR.ELEMENT_TYPE_ID=TO_NUMBER(HJP.PARAMETER_VALUE)
AND PRR.STATUS IN ('P'
, 'PA')
AND PRRV.RUN_RESULT_ID=PRR.RUN_RESULT_ID
AND PIV.INPUT_VALUE_ID=PRRV.INPUT_VALUE_ID
AND PPA.EFFECTIVE_DATE BETWEEN PIV.EFFECTIVE_START_DATE
AND PIV.EFFECTIVE_END_DATE
AND PIV.UOM <> 'M'
AND PIV.LOOKUP_TYPE <> 'JP_ITAX_TYPE'
AND PIVTL.INPUT_VALUE_ID=PIV.INPUT_VALUE_ID
AND PIVTL.LANGUAGE=USERENV('LANG')