APPS.BEN_PRC_BUS dependencies on PAY_RUN_RESULTS

Line 1551: select /*+ leading(d) use_nl(d i e h a j g b) index(h PAY_RUN_RESULTS_N50) */

1547: ,p_business_group_id in number
1548: ,p_assignment_id in number
1549: ,p_effective_date in date)
1550: is
1551: select /*+ leading(d) use_nl(d i e h a j g b) index(h PAY_RUN_RESULTS_N50) */
1552: max(g.end_date) end_date
1553: from
1554: pay_run_result_values a,
1555: pay_element_types_f b,

Line 1559: pay_run_results h,

1555: pay_element_types_f b,
1556: pay_assignment_actions d,
1557: pay_payroll_actions e,
1558: per_time_periods g,
1559: pay_run_results h,
1560: ben_acty_base_rt_f i,
1561: pay_input_values_f j
1562: where d.assignment_id = p_assignment_id
1563: and d.payroll_action_id = e.payroll_action_id