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.PQP_US_PENSION_EXTRACTS dependencies on PAY_RUN_RESULTS

Line 175: FROM pay_run_results prr

171: CURSOR csr_ele_run (c_asg_action_id IN NUMBER
172: ,c_element_type_id IN NUMBER
173: ) IS
174: SELECT 'X'
175: FROM pay_run_results prr
176: WHERE prr.assignment_action_id = c_asg_action_id
177: AND prr.element_type_id = c_element_type_id;
178: --AND prr.entry_type IN ('E','V','B')
179: --AND prr.status IN ('P','PA');

Line 215: FROM pay_run_results prr

211: CURSOR csr_run (c_asg_action_id IN NUMBER
212: ,c_element_type_id IN NUMBER
213: ,c_input_value_id IN NUMBER) IS
214: SELECT prv.result_value
215: FROM pay_run_results prr
216: ,pay_run_result_values prv
217: WHERE prr.assignment_action_id = c_asg_action_id
218: AND prr.element_type_id = c_element_type_id
219: AND prv.input_value_id = c_input_value_id