APPS.AP_EMPLOYEE_UPDATE_PKG dependencies on PER_ALL_PEOPLE_F

Line 73: FROM per_all_people_f ppf

69: ppf.last_name||', '||ppf.first_name||' '||ppf.middle_names)
70: per_vendor_name
71: , pv.vendor_id ven_vendor_id
72: , pv.vendor_name ven_vendor_name
73: FROM per_all_people_f ppf
74: , ap_suppliers pv
75: WHERE pv.employee_id = ppf.person_id
76: AND ppf.business_group_id = g_business_group_id
77: AND trunc(sysdate)

Line 93: FROM per_all_people_f ppf1

89: ppf.last_name||', '||ppf.first_name||' '||ppf.middle_names)
90: = pv1.vendor_name)
91: --Bug 2987396 eliminate employees with same name
92: AND not exists (SELECT 'Different Emp with Same Name'
93: FROM per_all_people_f ppf1
94: WHERE ppf1.person_id <> ppf.person_id
95: AND trunc(sysdate) BETWEEN ppf1.effective_start_date
96: AND ppf1.effective_end_date
97: AND DECODE(ppf1.middle_names, null, ppf1.last_name||

Line 114: FROM per_all_people_f ppf

110: ppf.last_name||', '||ppf.first_name||' '||ppf.middle_names)
111: per_vendor_name
112: , pv.vendor_id ven_vendor_id
113: , pv.vendor_name ven_vendor_name
114: FROM per_all_people_f ppf
115: , ap_suppliers pv
116: WHERE pv.employee_id = ppf.person_id
117: AND ppf.business_group_id = g_business_group_id
118: AND trunc(sysdate)

Line 134: FROM per_all_people_f ppf1

130: = pv1.vendor_name)
131: AND pv.vendor_name between p_from_supplier and p_to_supplier
132: --Bug 2987396 eliminate employees with same name.
133: AND not exists (SELECT 'Different Emp with Same Name'
134: FROM per_all_people_f ppf1
135: WHERE ppf1.person_id <> ppf.person_id
136: AND trunc(sysdate) BETWEEN ppf1.effective_start_date
137: AND ppf1.effective_end_date
138: AND DECODE(ppf1.middle_names, null, ppf1.last_name||

Line 157: , per_all_people_f ppf

153: , pv.vendor_name ven_vendor_name
154: , pv.end_date_active ven_idate
155: FROM per_all_assignments_f paf
156: , per_periods_of_service ppos
157: , per_all_people_f ppf
158: , ap_suppliers pv
159: WHERE pv.employee_id = ppf.person_id
160: AND ppf.person_id = paf.person_id
161: AND ppf.person_id = ppos.person_id

Line 191: , per_all_people_f ppf

187: , pv.vendor_name ven_vendor_name
188: , pv.end_date_active ven_idate
189: FROM per_all_assignments_f paf
190: , per_periods_of_service ppos
191: , per_all_people_f ppf
192: , ap_suppliers pv
193: WHERE pv.employee_id = ppf.person_id
194: AND ppf.person_id = paf.person_id
195: AND ppf.person_id = ppos.person_id