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

Line 2182: per_periods_of_service pds

2178: pds.actual_termination_date,
2179: pds.leaving_reason,
2180: pds.date_start
2181: from per_all_people_f per,
2182: per_periods_of_service pds
2183: where per.person_id = c_person_id
2184: and per.person_id = pds.person_id
2185: and c_eff_date
2186: between per.effective_start_date and per.effective_end_date

Line 2187: and pds.date_start = (select max(date_start) from per_periods_of_service

2183: where per.person_id = c_person_id
2184: and per.person_id = pds.person_id
2185: and c_eff_date
2186: between per.effective_start_date and per.effective_end_date
2187: and pds.date_start = (select max(date_start) from per_periods_of_service
2188: pps where pps.person_id = c_person_id) ;
2189: --
2190: cursor c_getempabsence
2191: (c_person_id in number