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 PER_ALL_PEOPLE_F

Line 72: FROM per_all_people_f ppf

68: Cursor Name_Cur Is
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)

Line 88: FROM per_all_people_f ppf

84: CURSOR name_cur1 IS
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)

Line 107: , per_all_people_f ppf

103: , pv.vendor_name ven_vendor_name
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

Line 149: , per_all_people_f ppf

145: , pv.vendor_name ven_vendor_name
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