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_AC_ACTION_ARCH dependencies on PAY_RUN_RESULT_VALUES

Line 1328: pay_run_result_values prrv,

1324: sum(decode(piv.name, 'Hours', prrv.result_value)),
1325: nvl(sum(decode(piv.name, 'Multiple', prrv.result_value)),1),
1326: sum(decode(piv.name, 'Rate', prrv.result_value))
1327: from pay_run_results prr,
1328: pay_run_result_values prrv,
1329: pay_input_values_f piv,
1330: pay_entry_process_details pepd
1331: where piv.input_value_id = prrv.input_value_id
1332: and prr.element_type_id = cp_element_type_id

Line 4321: pay_run_result_values prrv,

4317:
4318: CURSOR get_run_results ( cp_element_entry_id in number ) IS
4319: SELECT to_number(prrv.result_value), pivf.NAME
4320: FROM pay_run_results prr,
4321: pay_run_result_values prrv,
4322: pay_input_values_f pivf
4323: WHERE prr.element_entry_id = cp_element_entry_id
4324: AND prrv.run_result_id = prr.run_result_id
4325: AND prrv.input_value_id = pivf.input_value_id

Line 4334: pay_run_result_values prrv,

4330: --
4331: CURSOR get_run_results_rate( cp_element_entry_id in number ) IS
4332: SELECT to_number(prrv.result_value)
4333: FROM pay_run_results prr,
4334: pay_run_result_values prrv,
4335: pay_input_values_f pivf
4336: WHERE prr.element_entry_id = cp_element_entry_id
4337: AND prrv.run_result_id = prr.run_result_id
4338: AND prrv.input_value_id = pivf.input_value_id

Line 4815: pay_run_result_values prrv,

4811: CURSOR get_run_results ( cp_run_action_id in number ,cp_element_entry_id in number ) IS
4812: --bug 7373188
4813: SELECT to_number(prrv.result_value), pivf.NAME
4814: FROM pay_run_results prr,
4815: pay_run_result_values prrv,
4816: pay_input_values_f pivf
4817: WHERE prr.element_entry_id = cp_element_entry_id
4818: --bug 7373188
4819: and prr.assignment_action_id = cp_run_action_id

Line 4833: pay_run_result_values prrv,

4829: CURSOR get_run_results_rate( cp_run_action_id in number , cp_element_entry_id in number ) IS
4830: --bug 7373188
4831: SELECT to_number(prrv.result_value)
4832: FROM pay_run_results prr,
4833: pay_run_result_values prrv,
4834: pay_input_values_f pivf
4835: WHERE prr.element_entry_id = cp_element_entry_id
4836: --bug 7373188
4837: and prr.assignment_action_id = cp_run_action_id