DBA Data[Home] [Help]

APPS.PAY_AU_LEAVE_LIABILITY dependencies on PAY_ELEMENT_ENTRIES_F

Line 48: ',pay_element_entries_f ee ' ||

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

Line 108: , pay_element_entries_f ee

104: ,p_end_person_id number) is
105: select distinct a.assignment_id
106: from pay_payroll_actions pa
107: , per_assignments_f a
108: , pay_element_entries_f ee
109: , pay_element_links_f el
110: , pay_accrual_plans ap
111: where pa.payroll_action_id = p_payroll_action_id
112: and a.business_group_id = pa.business_group_id

Line 232: , pay_element_entries_f ee

228: , a.payroll_id
229: from pay_assignment_actions aa
230: , pay_payroll_actions pa
231: , per_assignments_f a
232: , pay_element_entries_f ee
233: , pay_element_links_f el
234: , pay_accrual_plans ap
235: where aa.assignment_action_id = p_assignment_action_id
236: and pa.payroll_action_id = aa.payroll_action_id