eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_US_ACTION_ARCH dependencies on PAY_RUN_RESULT_VALUES

Line 168: pay_run_result_values and other

164: and assignment is returned
165: only once.
166: 4212744 Changed cursor c_get_baladj_jd
167: to remove join to
168: pay_run_result_values and other
169: tables.
170: 05-NOV-2004 ahanda 115.94 3995766 Archiver not archiving
171: Balance Adjustment and Reversal
172: 03-NOV-2004 ahanda 115.93 3979501 Added support for RANGE_PERSON_ID

Line 1902: pay_run_result_values prrv,

1898: sum(decode(piv.name, 'Hours', prrv.result_value)),
1899: nvl(sum(decode(piv.name, 'Multiple', prrv.result_value)),1),
1900: sum(decode(piv.name, 'Rate', prrv.result_value))
1901: from pay_run_results prr,
1902: pay_run_result_values prrv,
1903: pay_input_values_f piv,
1904: pay_entry_process_details pepd
1905: where piv.input_value_id = prrv.input_value_id
1906: and prr.element_type_id = cp_element_type_id

Line 6262: pay_run_result_values prrv_att,

6258: pay_assignment_actions paa,
6259: pay_action_interlocks pai,
6260: pay_pre_payments ppp,
6261: pay_input_values_f piv_pay,
6262: pay_run_result_values prrv_att,
6263: pay_run_result_values prrv_pay,
6264: pay_element_types_f pet,
6265: pay_element_types_f pet_calc,
6266: pay_element_classifications pec

Line 6263: pay_run_result_values prrv_pay,

6259: pay_action_interlocks pai,
6260: pay_pre_payments ppp,
6261: pay_input_values_f piv_pay,
6262: pay_run_result_values prrv_att,
6263: pay_run_result_values prrv_pay,
6264: pay_element_types_f pet,
6265: pay_element_types_f pet_calc,
6266: pay_element_classifications pec
6267: where round(ppp.value ,2) = round(p_value ,2)

Line 6346: pay_run_result_values prrv_att,

6342: pay_assignment_actions paa,
6343: pay_action_interlocks pai,
6344: pay_pre_payments ppp,
6345: pay_input_values_f piv_pay,
6346: pay_run_result_values prrv_att,
6347: pay_run_result_values prrv_pay
6348: where round(ppp.value ,2) = round(p_value ,2)
6349: and ppp.pre_payment_id = p_pre_payment_id
6350: and ppp.assignment_action_id = pai.locking_action_id

Line 6347: pay_run_result_values prrv_pay

6343: pay_action_interlocks pai,
6344: pay_pre_payments ppp,
6345: pay_input_values_f piv_pay,
6346: pay_run_result_values prrv_att,
6347: pay_run_result_values prrv_pay
6348: where round(ppp.value ,2) = round(p_value ,2)
6349: and ppp.pre_payment_id = p_pre_payment_id
6350: and ppp.assignment_action_id = pai.locking_action_id
6351: and pai.locked_action_id = paa.assignment_action_id

Line 6404: pay_run_result_values prrv,

6400:
6401: cursor jur ( ass_act_id number, ele_type_id number, date_ear date ) IS
6402: select prrv.result_value
6403: from pay_run_results prr,
6404: pay_run_result_values prrv,
6405: pay_input_values_f piv,
6406: pay_element_types_f pet,
6407: pay_element_types_f pet1
6408: where prr.assignment_action_id = ass_act_id and

Line 6452: pay_run_result_values prrv_att,

6448: pay_payroll_actions ppa,
6449: pay_assignment_actions paa,
6450: pay_action_interlocks pai,
6451: pay_pre_payments ppp,
6452: pay_run_result_values prrv_att,
6453: pay_element_types_f pet,
6454: pay_element_classifications pec
6455: WHERE round(ppp.value ,2) = round(p_value ,2)
6456: and ppp.pre_payment_id = p_pre_payment_id