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.

[Home] [Help]

APPS.AP_EMPLOYEE_UPDATE_PKG dependencies on PER_PERIODS_OF_SERVICE

Line 106: , per_periods_of_service ppos

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
110: AND ppf.person_id = paf.person_id

Line 119: FROM per_periods_of_service ppos2

115: ppos.actual_termination_date)
116: BETWEEN paf.effective_start_date
117: AND paf.effective_end_date
118: AND ppos.date_start = (SELECT max(ppos2.date_start)
119: FROM per_periods_of_service ppos2
120: WHERE ppos2.person_id = ppos.person_id
121: AND ppos2.date_start <= trunc(sysdate))
122: AND trunc(sysdate)
123: BETWEEN ppf.effective_start_date

Line 148: , per_periods_of_service ppos

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
152: AND ppf.person_id = paf.person_id

Line 161: FROM per_periods_of_service ppos2

157: ppos.actual_termination_date)
158: BETWEEN paf.effective_start_date
159: AND paf.effective_end_date
160: AND ppos.date_start = (SELECT max(ppos2.date_start)
161: FROM per_periods_of_service ppos2
162: WHERE ppos2.person_id = ppos.person_id
163: AND ppos2.date_start <= trunc(sysdate))
164: AND trunc(sysdate)
165: BETWEEN ppf.effective_start_date