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.PER_IN_PERSON_TERM_LEG_HOOK dependencies on PER_PERIODS_OF_SERVICE

Line 195: FROM per_periods_of_service

191: CURSOR c_pds_details
192: IS
193: SELECT final_process_date
194: ,actual_termination_date
195: FROM per_periods_of_service
196: WHERE period_of_service_id = p_period_of_service_id;
197:
198: l_final_process_date DATE;
199: l_actual_termination_date DATE;

Line 276: FROM per_periods_of_service pos

272: --
273: CURSOR c_pos_dtls IS
274: SELECT pos.business_group_id
275: ,pos.actual_termination_date
276: FROM per_periods_of_service pos
277: WHERE pos.period_of_service_id = p_period_of_service_id;
278:
279: l_business_group_id NUMBER;
280: l_actual_termination_date DATE;

Line 457: FROM per_periods_of_service pos

453: IS
454: CURSOR c_pos_dtls IS
455: SELECT pos.actual_termination_date
456: ,ppf.business_group_id
457: FROM per_periods_of_service pos
458: ,per_assignments_f paf
459: ,per_people_f ppf
460: WHERE pos.period_of_service_id = p_period_of_service_id
461: AND pos.period_of_service_id = paf.period_of_service_id