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_CHECKLIST_EVENTS dependencies on PER_PERIODS_OF_SERVICE

Line 857: FROM per_periods_of_service ppos

853: WHERE papf.person_id = p_person_id
854: AND
855: (
856: SELECT max (ppos.date_start)
857: FROM per_periods_of_service ppos
858: WHERE ppos.person_id = p_person_id
859: ) BETWEEN papf.effective_start_date
860: AND papf.effective_end_date;*/ --Commented for Bug#12385504
861:

Line 867: FROM per_periods_of_service ppos

863: SELECT papf.full_name
864: FROM per_all_people_f papf,
865: (
866: SELECT to_date(max (ppos.date_start)) effective_date
867: FROM per_periods_of_service ppos
868: WHERE ppos.person_id = p_person_id
869: ) ppfe
870: WHERE papf.person_id = p_person_id
871: AND papf.effective_start_date =