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

Line 2605: ,PER_PERIODS_OF_SERVICE PPS

2601: ,pps.actual_termination_date actual_termination_date
2602: from per_all_people_f ppf
2603: ,per_all_assignments_f paf
2604: ,PER_PERIODS_OF_PLACEMENT PPP
2605: ,PER_PERIODS_OF_SERVICE PPS
2606: where ppf.person_id = paf.person_id
2607: and paf. assignment_type in ('E','B') -- Need to consider Ex-Employee too
2608: and p_effective_date between
2609: ppf.effective_start_date and ppf.effective_end_date

Line 2618: FROM PER_PERIODS_OF_SERVICE PPS1

2614: or
2615: (Ppf.EMPLOYEE_NUMBER IS NOT NULL
2616: AND PPS.DATE_START =
2617: (SELECT MAX(PPS1.DATE_START)
2618: FROM PER_PERIODS_OF_SERVICE PPS1
2619: WHERE PPS1.PERSON_ID = Ppf.PERSON_ID
2620: AND PPS1.DATE_START <= Ppf.EFFECTIVE_END_DATE)
2621: )
2622: )