DBA Data[Home] [Help]

APPS.HR_LEGISLATION_ELEMENTS dependencies on PAY_PAYROLL_ACTIONS

Line 1546: , pay_payroll_actions c

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

Line 1562: , pay_payroll_actions c

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
1566: and c.effective_date > r_distinct.c_end);