APPS.IRC_UTILITIES_PKG dependencies on PER_ALL_VACANCIES

Line 1567: PER_ALL_VACANCIES PAV,

1563: pav.primary_posting_id,
1564: 1) rlink
1565: FROM HR_LOOKUPS HRL,
1566: HR_LOOKUPS HL2,
1567: PER_ALL_VACANCIES PAV,
1568: PER_RECRUITMENT_ACTIVITIES PRA,
1569: PER_RECRUITMENT_ACTIVITY_FOR PRF,
1570: IRC_POSTING_CONTENTS_VL IPC,
1571: IRC_SEARCH_CRITERIA IVS,

Line 2413: from per_all_vacancies pav

2409:
2410: -- Cursor to fetch manager of the vacancy
2411: cursor c_manager(p_person_id in number, p_vacancy_id in number) is
2412: select pav.manager_id
2413: from per_all_vacancies pav
2414: where pav.vacancy_id = p_vacancy_id ;
2415:
2416: begin
2417: open c_manager(p_person_id, p_vacancy_id);