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.PER_VACANCIES_PKG dependencies on PER_RECRUITMENT_ACTIVITY_FOR

Line 96: , PER_RECRUITMENT_ACTIVITY_FOR PRAF

92:
93: CURSOR c_check_ref_2 IS
94: SELECT PV.NAME
95: FROM PER_VACANCIES PV
96: , PER_RECRUITMENT_ACTIVITY_FOR PRAF
97: WHERE PRAF.VACANCY_ID = P_vacancy_id
98: AND PV.VACANCY_ID = P_vacancy_id ;
99:
100: --

Line 465: FROM PER_RECRUITMENT_ACTIVITY_FOR F,

461: -- using the given vacancy where either of its start/end dates
462: -- are outside the vacancy dates.
463: CURSOR c_rec_act_chk IS
464: SELECT 1
465: FROM PER_RECRUITMENT_ACTIVITY_FOR F,
466: PER_RECRUITMENT_ACTIVITIES ACTS
467: WHERE F.VACANCY_ID = P_vacancy_id
468: AND F.RECRUITMENT_ACTIVITY_ID = ACTS.RECRUITMENT_ACTIVITY_ID
469: AND ( ACTS.DATE_START < P_vac_date_from