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

Line 601: FROM per_periods_of_service

597:
598: CURSOR c_actual_termination_date (v_person_id IN NUMBER)
599: IS
600: SELECT actual_termination_date
601: FROM per_periods_of_service
602: WHERE person_id = v_person_id
603: AND date_start = (SELECT MAX (date_start)
604: FROM per_periods_of_service
605: WHERE person_id = v_person_id

Line 604: FROM per_periods_of_service

600: SELECT actual_termination_date
601: FROM per_periods_of_service
602: WHERE person_id = v_person_id
603: AND date_start = (SELECT MAX (date_start)
604: FROM per_periods_of_service
605: WHERE person_id = v_person_id
606: GROUP BY person_id);
607:
608: CURSOR c_performance_promotion (v_pl_id IN NUMBER, v_lf_evt_ocrd_dt IN DATE)