DBA Data[Home] [Help]

APPS.HR_LEGISLATION_ELEMENTS dependencies on PAY_RUN_RESULTS

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

1537: select 1
1538: into l_null_return
1539: from dual
1540: where exists
1541: (select /*+ ORDERED INDEX(a PAY_RUN_RESULTS_PK)
1542: USE_NL(a b c) */ null
1543: from pay_run_result_values v
1544: , pay_run_results a
1545: , pay_assignment_actions b

Line 1544: , pay_run_results a

1540: where exists
1541: (select /*+ ORDERED INDEX(a PAY_RUN_RESULTS_PK)
1542: USE_NL(a b c) */ null
1543: from pay_run_result_values v
1544: , pay_run_results a
1545: , pay_assignment_actions b
1546: , pay_payroll_actions c
1547: where v.input_value_id = l_input_value_id
1548: and a.run_result_id = v.run_result_id

Line 1560: from pay_run_results a

1556: into l_null_return
1557: from dual
1558: where exists
1559: (select null
1560: from pay_run_results a
1561: , pay_assignment_actions b
1562: , pay_payroll_actions c
1563: where a.element_Type_id = l_new_element_type_id
1564: and b.assignment_action_id = a.assignment_action_id