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.IRC_UTILITIES_PKG dependencies on PER_VACANCIES

Line 617: ,per_vacancies per_vac

613: cursor csr_has_vac is
614: select 1
615: from per_all_people_f per_per
616: ,per_all_assignments_f per_asg
617: ,per_vacancies per_vac
618: where per_per.party_id=p_party_id
619: and p_eff_date between per_per.effective_start_date and per_per.effective_end_date
620: and per_per.person_id=per_asg.person_id
621: and

Line 1609: FROM per_vacancies vac1

1605: )
1606: )
1607: AND EXISTS
1608: (SELECT 1
1609: FROM per_vacancies vac1
1610: WHERE vac1.vacancy_id =pav.vacancy_id
1611: )
1612: AND pra.recruiting_site_id = ias.recruiting_site_id
1613: AND sysdate BETWEEN pra.date_start AND NVL (pra.date_end, sysdate)';