APPS.AP_EMPLOYEE_UPDATE_PKG dependencies on AP_SUPPLIERS

Line 74: , ap_suppliers pv

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)
78: BETWEEN ppf.effective_start_date

Line 86: FROM ap_suppliers pv1

82: null, ppf.last_name||', '||ppf.first_name,
83: ppf.last_name||', '||ppf.first_name||' '||ppf.middle_names)
84: <> pv.vendor_name
85: AND not exists (SELECT 'duplicate name exists'
86: FROM ap_suppliers pv1
87: WHERE DECODE(ppf.middle_names,
88: null, ppf.last_name||', '||ppf.first_name,
89: ppf.last_name||', '||ppf.first_name||' '||ppf.middle_names)
90: = pv1.vendor_name)

Line 115: , ap_suppliers pv

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)
119: BETWEEN ppf.effective_start_date

Line 126: FROM ap_suppliers pv1

122: null, ppf.last_name||', '||ppf.first_name,
123: ppf.last_name||', '||ppf.first_name||' '||ppf.middle_names)
124: <> pv.vendor_name
125: AND not exists (SELECT 'duplicate name exists'
126: FROM ap_suppliers pv1
127: WHERE DECODE(ppf.middle_names,
128: null, ppf.last_name||', '||ppf.first_name,
129: ppf.last_name||', '||ppf.first_name||' '||ppf.middle_names)
130: = pv1.vendor_name)

Line 158: , ap_suppliers pv

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
162: AND ppf.business_group_id = g_business_group_id

Line 192: , ap_suppliers pv

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
196: AND ppf.business_group_id = g_business_group_id

Line 248: UPDATE ap_suppliers

244: FOR name_rec IN name_cur LOOP
245:
246: IF nvl(name_rec.ven_vendor_name,'EMPTY') <> nvl(name_rec.per_vendor_name,'EMPTY') THEN
247:
248: UPDATE ap_suppliers
249: SET vendor_name = name_rec.per_vendor_name
250: ,last_update_date = sysdate -- Bug 3191168
251: ,last_updated_by = fnd_global.user_id -- Bug 3191168
252: ,last_update_login = fnd_global.login_id -- Bug 3191168

Line 274: UPDATE ap_suppliers

270: ,last_update_login = fnd_global.login_id -- Bug 3191168
271: WHERE vendor_id = inactive_rec.ven_vendor_id;
272:
273: /* Bug 1561680 */
274: UPDATE ap_suppliers
275: SET end_date_active = inactive_rec.per_idate
276: ,last_update_date = sysdate -- Bug 3191168
277: ,last_updated_by = fnd_global.user_id -- Bug 3191168
278: ,last_update_login = fnd_global.login_id -- Bug 3191168

Line 292: UPDATE ap_suppliers

288: FOR name_rec1 IN name_cur1 LOOP
289:
290: IF nvl(name_rec1.ven_vendor_name,'EMPTY') <> nvl(name_rec1.per_vendor_name,'EMPTY') THEN
291:
292: UPDATE ap_suppliers
293: SET vendor_name = name_rec1.per_vendor_name
294: ,last_update_date = sysdate -- Bug 3191168
295: ,last_updated_by = fnd_global.user_id -- Bug 3191168
296: ,last_update_login = fnd_global.login_id -- Bug 3191168

Line 316: UPDATE ap_suppliers

312: ,last_update_login = fnd_global.login_id -- Bug 3191168
313: WHERE vendor_id = inactive_rec1.ven_vendor_id;
314:
315: /* Bug 1561680 */
316: UPDATE ap_suppliers
317: SET end_date_active = inactive_rec1.per_idate
318: ,last_update_date = sysdate -- Bug 3191168
319: ,last_updated_by = fnd_global.user_id -- Bug 3191168
320: ,last_update_login = fnd_global.login_id -- Bug 3191168