APPS.IRC_CMP_UPGRADE dependencies on IRC_COMM_PROPERTIES
Line 20: from irc_comm_properties icp
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
23: )
24: and pav.vacancy_id between p_start_pkid and p_end_pkid;