DBA Data[Home] [Help]

APPS.HR_LEGISLATION_ELEMENTS dependencies on PAY_PAYROLL_ACTIONS

Line 1567: , pay_payroll_actions c

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
1570: and b.assignment_action_id = a.assignment_action_id
1571: and c.payroll_action_id = b.payroll_action_id

Line 1583: , pay_payroll_actions c

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
1586: and c.payroll_action_id = b.payroll_action_id
1587: and c.effective_date > r_distinct.c_end);