DBA Data[Home] [Help]

APPS.PAY_PURGE_PKG dependencies on PAY_RUN_RESULTS

Line 433: index (prr PAY_RUN_RESULTS_N1)

429: -- NOTE: The Purge assignment actions must be already prepared.
430: --
431: select
432: /*+ ordered
433: index (prr PAY_RUN_RESULTS_N1)
434: index (purge_paa PAY_ASSIGNMENT_ACTIONS_N51)
435: use_nl (piv prr paa ppa purge_paa prrv) */
436: 1
437: from

Line 440: ,pay_run_results prr

436: 1
437: from
438: pay_balance_feeds_f pbf
439: ,pay_input_values_f piv
440: ,pay_run_results prr
441: ,pay_assignment_actions paa
442: ,pay_payroll_actions ppa
443: ,pay_assignment_actions purge_paa
444: ,pay_run_result_values prrv