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 1637: pay_run_result_values prrv,

1633: sum(decode(piv.name, 'Hours', prrv.result_value)),
1634: nvl(sum(decode(piv.name, 'Multiple', prrv.result_value)),1),
1635: sum(decode(piv.name, 'Rate', prrv.result_value))
1636: from pay_run_results prr,
1637: pay_run_result_values prrv,
1638: pay_input_values_f piv,
1639: pay_entry_process_details pepd
1640: where piv.input_value_id = prrv.input_value_id
1641: and prr.element_type_id = cp_element_type_id

Line 4834: pay_run_result_values prrv,

4830: ,cp_pymt_eff_date in date -- Bug# 16318258
4831: ) IS
4832: SELECT to_number(prrv.result_value), pivf.NAME
4833: FROM pay_run_results prr,
4834: pay_run_result_values prrv,
4835: pay_input_values_f pivf
4836: WHERE prr.assignment_action_id = cp_run_assignment_action_id
4837: AND prr.element_entry_id = cp_element_entry_id
4838: AND prrv.run_result_id = prr.run_result_id

Line 4852: pay_run_result_values PRRV,

4848: ,cp_pymt_eff_date in date -- Bug# 16318258
4849: ) is
4850: select PRRV.RESULT_VALUE as original_input_value
4851: from pay_run_results PRR,
4852: pay_run_result_values PRRV,
4853: pay_input_values_f PIVF,
4854: pay_entry_process_details PEPD
4855: WHERE PEPD.ELEMENT_ENTRY_ID = cp_element_entry_id
4856: AND PEPD.SOURCE_ENTRY_ID = PRR.SOURCE_ID

Line 4876: pay_run_result_values prrv,

4872: ,cp_pymt_eff_date in date -- Bug# 16318258
4873: ) IS
4874: SELECT to_number(prrv.result_value)
4875: FROM pay_run_results prr,
4876: pay_run_result_values prrv,
4877: pay_input_values_f pivf
4878: WHERE prr.assignment_action_id = cp_run_assignment_action_id
4879: AND prr.element_entry_id = cp_element_entry_id
4880: AND prrv.run_result_id = prr.run_result_id

Line 5428: pay_run_result_values prrv,

5424: ) IS
5425: --bug 7373188
5426: SELECT to_number(prrv.result_value), pivf.NAME
5427: FROM pay_run_results prr,
5428: pay_run_result_values prrv,
5429: pay_input_values_f pivf
5430: WHERE prr.element_entry_id = cp_element_entry_id
5431: --bug 7373188
5432: and prr.assignment_action_id = cp_run_action_id

Line 5449: pay_run_result_values prrv,

5445: ) IS
5446: --bug 7373188
5447: SELECT to_number(prrv.result_value)
5448: FROM pay_run_results prr,
5449: pay_run_result_values prrv,
5450: pay_input_values_f pivf
5451: WHERE prr.element_entry_id = cp_element_entry_id
5452: --bug 7373188
5453: and prr.assignment_action_id = cp_run_action_id

Line 6029: pay_run_result_values prrv,

6025: ) IS
6026: --bug 7373188
6027: SELECT to_number(prrv.result_value), pivf.NAME
6028: FROM pay_run_results prr,
6029: pay_run_result_values prrv,
6030: pay_input_values_f pivf
6031: WHERE prr.element_entry_id = cp_element_entry_id
6032: --bug 7373188
6033: and prr.assignment_action_id = cp_run_action_id

Line 6050: pay_run_result_values prrv,

6046: ) IS
6047: --bug 7373188
6048: SELECT to_number(prrv.result_value)
6049: FROM pay_run_results prr,
6050: pay_run_result_values prrv,
6051: pay_input_values_f pivf
6052: WHERE prr.element_entry_id = cp_element_entry_id
6053: --bug 7373188
6054: and prr.assignment_action_id = cp_run_action_id