DBA Data[Home] [Help]

APPS.HR_LEGISLATION_ELEMENTS dependencies on PAY_RUN_RESULTS

Line 1562: (select /*+ ORDERED INDEX(a PAY_RUN_RESULTS_PK)

1558: select 1
1559: into l_null_return
1560: from dual
1561: where exists
1562: (select /*+ ORDERED INDEX(a PAY_RUN_RESULTS_PK)
1563: USE_NL(a b c) */ null
1564: from pay_run_result_values v
1565: , pay_run_results a
1566: , pay_assignment_actions b

Line 1565: , pay_run_results a

1561: where exists
1562: (select /*+ ORDERED INDEX(a PAY_RUN_RESULTS_PK)
1563: USE_NL(a b c) */ null
1564: from pay_run_result_values v
1565: , pay_run_results a
1566: , pay_assignment_actions b
1567: , pay_payroll_actions c
1568: where v.input_value_id = l_input_value_id
1569: and a.run_result_id = v.run_result_id

Line 1581: from pay_run_results a

1577: into l_null_return
1578: from dual
1579: where exists
1580: (select null
1581: from pay_run_results a
1582: , pay_assignment_actions b
1583: , pay_payroll_actions c
1584: where a.element_Type_id = l_new_element_type_id
1585: and b.assignment_action_id = a.assignment_action_id