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_PERIODS_OF_SERVICE

Line 156: , per_periods_of_service ppos

152: , pv.vendor_id ven_vendor_id
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

Line 169: FROM per_periods_of_service ppos2

165: ppos.actual_termination_date)
166: BETWEEN paf.effective_start_date
167: AND paf.effective_end_date
168: AND ppos.date_start = (SELECT max(ppos2.date_start)
169: FROM per_periods_of_service ppos2
170: WHERE ppos2.person_id = ppos.person_id
171: AND ppos2.date_start <= trunc(sysdate))
172: AND trunc(sysdate)
173: BETWEEN ppf.effective_start_date

Line 190: , per_periods_of_service ppos

186: , pv.vendor_id ven_vendor_id
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

Line 203: FROM per_periods_of_service ppos2

199: ppos.actual_termination_date)
200: BETWEEN paf.effective_start_date
201: AND paf.effective_end_date
202: AND ppos.date_start = (SELECT max(ppos2.date_start)
203: FROM per_periods_of_service ppos2
204: WHERE ppos2.person_id = ppos.person_id
205: AND ppos2.date_start <= trunc(sysdate))
206: AND trunc(sysdate)
207: BETWEEN ppf.effective_start_date