The following lines contain the word 'select', 'insert', 'update' or 'delete':
select a.country_of_birth
into l_cnty_of_birth
from per_all_people_f a,
per_contact_relationships b
where a.person_id = b.contact_person_id and
b.person_id = p_person_id and
b.contact_type = p_contact_type and
p_session_date between a.effective_start_date and a.effective_end_date and
p_session_date between nvl(b.date_start, p_session_date) and
nvl(b.date_end, p_session_date) and
ROWNUM = 1
order by b.date_start desc;
select a.country_of_birth
into l_cnty_of_birth
from per_all_people_f a,
per_contact_relationships b
where a.person_id = b.contact_person_id and
b.person_id = p_person_id and
b.contact_type = p_contact_type and
p_session_date between nvl(b.date_start, p_session_date) and
nvl(b.date_end, p_session_date) and
ROWNUM = 1
order by b.date_start desc, a.effective_start_date desc;
select formula_id ,effective_start_date
into l_formula_id,l_effective_start_date
from ff_formulas_f_v
where formula_name = 'NL_TARGET_GROUP'
and p_session_date between effective_start_date and
effective_end_date
and verified = 'Y';
select per_information11, per_information12
into l_local_birth_country_fth, l_local_birth_country_mth
from per_all_people_f
where person_id = p_person_id
and p_session_date between effective_start_date
and effective_end_date;
select country_of_birth,
business_group_id
into l_country_of_birth_emp,
l_business_group_id
from per_all_people_f
where person_id = p_person_id and
p_session_date between effective_start_date and effective_end_date;