DBA Data[Home] [Help]

APPS.HR_LEGISLATION_ELEMENTS dependencies on PAY_ASSIGNMENT_ACTIONS

Line 1545: , pay_assignment_actions b

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
1549: and b.assignment_action_id = a.assignment_action_id

Line 1561: , pay_assignment_actions b

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
1565: and c.payroll_action_id = b.payroll_action_id