APPS.IRC_CMP_UPGRADE dependencies on PER_ALL_VACANCIES

Line 18: from per_all_vacancies pav

14: l_rows_processed number := 0;
15: --
16: cursor csr_vacancy is
17: select pav.vacancy_id
18: from per_all_vacancies pav
19: where not exists (select null
20: from irc_comm_properties icp
21: where icp.object_type = 'VACANCY'
22: and icp.object_id = pav.vacancy_id