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

Line 827: from per_periods_of_service pps

823: --
824:
825: cursor c_pps is
826: select date_start
827: from per_periods_of_service pps
828: where pps.person_id = p_person_id
829: and pps.date_start = (select max(pps1.date_start) -- this gets most recent
830: from per_periods_of_service pps1
831: where pps1.person_id = p_person_id

Line 830: from per_periods_of_service pps1

826: select date_start
827: from per_periods_of_service pps
828: where pps.person_id = p_person_id
829: and pps.date_start = (select max(pps1.date_start) -- this gets most recent
830: from per_periods_of_service pps1
831: where pps1.person_id = p_person_id
832: and pps1.date_start = nvl(l_lf_evt_ocrd_dt,p_effective_date )
833: );
834: --

Line 837: from per_periods_of_service pps

833: );
834: --
835: cursor c_hire_date is
836: select max(date_start)
837: from per_periods_of_service pps
838: where pps.person_id = p_person_id
839: and pps.date_start <= nvl(l_lf_evt_ocrd_dt,p_effective_date);
840:
841: --