The following lines contain the word 'select', 'insert', 'update' or 'delete':
select ppf.person_id
from per_assignments_f paf
,per_people_f ppf
where paf.person_id = l_in_person_id
and paf.primary_flag = 'Y'
and (paf.assignment_type = 'E' and ppf.current_employee_flag = 'Y'
or paf.assignment_type = 'C' and ppf.current_npw_flag = 'Y')
and sysdate
between paf.effective_start_date
and paf.effective_end_date
and ppf.person_id = paf.supervisor_id
and sysdate
between ppf.effective_start_date
and ppf.effective_end_date;
SELECT email_address
FROM per_people_f pp
WHERE pp.person_id = p_person_id
AND l_effective_date
between pp.effective_start_date
and pp.effective_end_date;
SELECT recruiter_id,job_id
FROM per_vacancies pv
WHERE pv.vacancy_id = p_vacancy_id;
select 1
from wf_item_attribute_values wiav
where wiav.item_type = p_item_type
and wiav.item_key = p_item_key
and wiav.name = p_name;