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_PLACEMENT

Line 2604: ,PER_PERIODS_OF_PLACEMENT PPP

2600: END) HIRE_DATE
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

Line 2628: FROM PER_PERIODS_OF_PLACEMENT PPP1

2624: OR
2625: (Ppf.NPW_NUMBER IS NOT NULL AND
2626: PPP.DATE_START =
2627: (SELECT MAX(PPP1.DATE_START)
2628: FROM PER_PERIODS_OF_PLACEMENT PPP1
2629: WHERE PPP1.PERSON_ID = Ppf.PERSON_ID
2630: AND PPP1.DATE_START <= Ppf.EFFECTIVE_END_DATE
2631: )
2632: )