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.HR_ORI_BUS dependencies on PER_PERIODS_OF_SERVICE

Line 339: from per_periods_of_service

335: --
336: cursor c1 is
337: select period_of_service_id worker_id,
338: date_start
339: from per_periods_of_service
340: where l_start_date
341: between date_start
342: and nvl(actual_termination_date,hr_api.g_eot)
343: and person_id = l_person_id

Line 359: from per_periods_of_service

355: -- WWBUG 2358813.
356: --
357: cursor c2(p_worker_id number) is
358: select actual_termination_date
359: from per_periods_of_service
360: where nvl(l_end_date,hr_api.g_eot)
361: between date_start
362: and nvl(actual_termination_date,hr_api.g_eot)
363: and period_of_service_id = p_worker_id