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_PLACEMENT

Line 347: from per_periods_of_placement

343: and person_id = l_person_id
344: union
345: select period_of_placement_id worker_id,
346: date_start
347: from per_periods_of_placement
348: where l_start_date
349: between date_start
350: and nvl(actual_termination_date,hr_api.g_eot)
351: and person_id = l_person_id;

Line 367: from per_periods_of_placement

363: and period_of_service_id = p_worker_id
364: and person_id = l_person_id
365: union
366: select actual_termination_date
367: from per_periods_of_placement
368: where nvl(l_end_date,hr_api.g_eot)
369: between date_start
370: and nvl(actual_termination_date,hr_api.g_eot)
371: and period_of_placement_id = p_worker_id