The following lines contain the word 'select', 'insert', 'update' or 'delete':
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;