APPS.IRC_CMP_UPGRADE SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 17

  select pav.vacancy_id
    from per_all_vacancies pav
   where not exists (select null
                     from irc_comm_properties icp
                     where icp.object_type = 'VACANCY'
              and  icp.object_id = pav.vacancy_id
             )
   and pav.vacancy_id between p_start_pkid  and p_end_pkid;