DBA Data[Home] [Help]

APPS.PAY_NZ_LEAVE_LIABILITY dependencies on PER_ASSIGNMENTS_F

Line 46: ',per_assignments_f a ' ||

42:
43: l_sql := 'select distinct p.person_id ' ||
44: 'from per_people_f p ' ||
45: ',pay_payroll_actions pa ' ||
46: ',per_assignments_f a ' ||
47: ',pay_element_entries_f ee ' ||
48: ',pay_element_links_f el ' ||
49: ',pay_accrual_plans ap ' ||
50: 'where pa.payroll_action_id = :payroll_action_id ' ||

Line 103: , per_assignments_f a

99: ,p_start_person_id number
100: ,p_end_person_id number) is
101: select distinct a.assignment_id
102: from pay_payroll_actions pa
103: , per_assignments_f a
104: , pay_element_entries_f ee
105: , pay_element_links_f el
106: , pay_accrual_plans ap
107: where pa.payroll_action_id = p_payroll_action_id

Line 218: , per_assignments_f a

214: select ap.accrual_plan_id
215: , a.payroll_id
216: from pay_assignment_actions aa
217: , pay_payroll_actions pa
218: , per_assignments_f a
219: , pay_element_entries_f ee
220: , pay_element_links_f el
221: , pay_accrual_plans ap
222: where aa.assignment_action_id = p_assignment_action_id