APPS.PAY_JP_RETRO_PKG dependencies on PAY_RUN_RESULTS

Line 154: INDEX(RR PAY_RUN_RESULTS_N51)

150: SELECT /*+ ORDERED
151: INDEX(BACT_ASSACT PAY_ASSIGNMENT_ACTIONS_N1)
152: INDEX(PEPD PAY_ENTRY_PROCESS_DETAILS_FK2)
153: INDEX(BACT PAY_PAYROLL_ACTIONS_PK)
154: INDEX(RR PAY_RUN_RESULTS_N51)
155: INDEX(ASSACT PAY_ASSIGNMENT_ACTIONS_PK)
156: INDEX(PACT PAY_PAYROLL_ACTIONS_PK)
157: INDEX(PEE PAY_ELEMENT_ENTRIES_F_PK)
158: INDEX(TARGET PAY_RUN_RESULT_VALUES_N50)

Line 263: pay_run_results RR, -- target result

259: -- target feed(use balance_type_id)
260: FROM pay_assignment_actions BACT_ASSACT, -- retro assact
261: pay_entry_process_details PEPD, -- retro entries
262: pay_payroll_actions BACT, -- retro pact
263: pay_run_results RR, -- target result
264: pay_assignment_actions ASSACT, -- target assact
265: pay_payroll_actions PACT, -- target pact
266: pay_element_entries_f PEE, -- retro element entries
267: pay_run_result_values TARGET, -- target result value

Line 296: INDEX(RR PAY_RUN_RESULTS_N51)

292: SELECT /*+ ORDERED
293: INDEX(BACT_ASSACT PAY_ASSIGNMENT_ACTIONS_N1)
294: INDEX(PEPD PAY_ENTRY_PROCESS_DETAILS_FK2)
295: INDEX(BACT PAY_PAYROLL_ACTIONS_PK)
296: INDEX(RR PAY_RUN_RESULTS_N51)
297: INDEX(ASSACT PAY_ASSIGNMENT_ACTIONS_PK)
298: INDEX(PACT PAY_PAYROLL_ACTIONS_PK)
299: INDEX(PEE PAY_ELEMENT_ENTRIES_F_PK)
300: INDEX(TARGET PAY_RUN_RESULT_VALUES_N50)

Line 307: pay_run_results RR,

303: INTO g_retro_diff_value
304: FROM pay_assignment_actions BACT_ASSACT,
305: pay_entry_process_details PEPD,
306: pay_payroll_actions BACT,
307: pay_run_results RR,
308: pay_assignment_actions ASSACT,
309: pay_payroll_actions PACT,
310: pay_element_entries_f PEE,
311: pay_run_result_values TARGET,