DBA Data[Home] [Help]

APPS.AP_EMPLOYEE_UPDATE_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 105: FROM per_all_assignments_f paf

101: SELECT nvl(ppos.final_process_date,ppos.actual_termination_date) per_idate /* bug 9456397*/
102: , pv.vendor_id ven_vendor_id
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

Line 147: FROM per_all_assignments_f paf

143: SELECT nvl(ppos.final_process_date,ppos.actual_termination_date) per_idate
144: , pv.vendor_id ven_vendor_id
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