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 612: FROM per_periods_of_service

608:
609: CURSOR c_actual_termination_date (v_person_id IN NUMBER)
610: IS
611: SELECT actual_termination_date
612: FROM per_periods_of_service
613: WHERE person_id = v_person_id
614: AND date_start = (SELECT MAX (date_start)
615: FROM per_periods_of_service
616: WHERE person_id = v_person_id

Line 615: FROM per_periods_of_service

611: SELECT actual_termination_date
612: FROM per_periods_of_service
613: WHERE person_id = v_person_id
614: AND date_start = (SELECT MAX (date_start)
615: FROM per_periods_of_service
616: WHERE person_id = v_person_id
617: GROUP BY person_id);
618:
619: CURSOR c_performance_promotion (v_pl_id IN NUMBER, v_lf_evt_ocrd_dt IN DATE)