APPS.PAY_US_ACTION_ARCH dependencies on PAY_RUN_RESULT_VALUES

Line 84: pay_run_result_values and other

80: and assignment is returned
81: only once.
82: 4212744 Changed cursor c_get_baladj_jd
83: to remove join to
84: pay_run_result_values and other
85: tables.
86: 05-NOV-2004 ahanda 115.94 3995766 Archiver not archiving
87: Balance Adjustment and Reversal
88: 03-NOV-2004 ahanda 115.93 3979501 Added support for RANGE_PERSON_ID

Line 1567: pay_run_result_values prrv,

1563: sum(decode(piv.name, 'Hours', prrv.result_value)),
1564: nvl(sum(decode(piv.name, 'Multiple', prrv.result_value)),1),
1565: sum(decode(piv.name, 'Rate', prrv.result_value))
1566: from pay_run_results prr,
1567: pay_run_result_values prrv,
1568: pay_input_values_f piv,
1569: pay_entry_process_details pepd
1570: where piv.input_value_id = prrv.input_value_id
1571: and prr.element_type_id = cp_element_type_id