eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AP_EMPLOYEE_UPDATE_PKG dependencies on AP_SUPPLIERS

Line 73: , ap_suppliers pv

69: SELECT ppf.full_name per_vendor_name /*Bug9615008 */
70: , pv.vendor_id ven_vendor_id
71: , pv.vendor_name ven_vendor_name
72: FROM per_all_people_f ppf
73: , ap_suppliers pv
74: WHERE pv.employee_id = ppf.person_id
75: AND ppf.business_group_id = p_business_group_id --bug 10402551 replaced g_business_group_id with p_business_group_id
76: AND trunc(sysdate)
77: BETWEEN ppf.effective_start_date

Line 89: , ap_suppliers pv

85: SELECT ppf.full_name per_vendor_name
86: , pv.vendor_id ven_vendor_id
87: , pv.vendor_name ven_vendor_name
88: FROM per_all_people_f ppf
89: , ap_suppliers pv
90: WHERE pv.employee_id = ppf.person_id
91: AND ppf.business_group_id = p_business_group_id --bug 10402551 replaced g_business_group_id with p_business_group_id
92: AND trunc(sysdate)
93: BETWEEN ppf.effective_start_date

Line 108: , ap_suppliers pv

104: , pv.end_date_active ven_idate
105: FROM per_all_assignments_f paf
106: , per_periods_of_service ppos
107: , per_all_people_f ppf
108: , ap_suppliers pv
109: WHERE pv.employee_id = ppf.person_id
110: AND ppf.person_id = paf.person_id
111: AND ppf.person_id = ppos.person_id
112: AND ppf.business_group_id = p_business_group_id --bug 10402551 replaced g_business_group_id with p_business_group_id

Line 150: , ap_suppliers pv

146: , pv.end_date_active ven_idate
147: FROM per_all_assignments_f paf
148: , per_periods_of_service ppos
149: , per_all_people_f ppf
150: , ap_suppliers pv
151: WHERE pv.employee_id = ppf.person_id
152: AND ppf.person_id = paf.person_id
153: AND ppf.person_id = ppos.person_id
154: AND ppf.business_group_id = p_business_group_id --bug 10402551 replaced g_business_group_id with p_business_group_id

Line 206: UPDATE ap_suppliers

202:
203: FOR name_rec IN name_cur LOOP
204:
205: IF nvl(name_rec.ven_vendor_name,'EMPTY') <> nvl(name_rec.per_vendor_name,'EMPTY') THEN
206: UPDATE ap_suppliers
207: SET vendor_name = name_rec.per_vendor_name
208: ,last_update_date = sysdate -- Bug 3191168
209: ,last_updated_by = fnd_global.user_id -- Bug 3191168
210: ,last_update_login = fnd_global.login_id -- Bug 3191168

Line 232: UPDATE ap_suppliers

228: ,last_update_login = fnd_global.login_id -- Bug 3191168
229: WHERE vendor_id = inactive_rec.ven_vendor_id;
230:
231: /* Bug 1561680 */
232: UPDATE ap_suppliers
233: SET end_date_active = inactive_rec.per_idate
234: ,last_update_date = sysdate -- Bug 3191168
235: ,last_updated_by = fnd_global.user_id -- Bug 3191168
236: ,last_update_login = fnd_global.login_id -- Bug 3191168

Line 249: UPDATE ap_suppliers

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

Line 273: UPDATE ap_suppliers

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