The following lines contain the word 'select', 'insert', 'update' or 'delete':
select date_start,person_id,projected_termination_date
from per_periods_of_placement
where period_of_placement_id between p_start_pkid and p_end_pkid
and projected_termination_date is not null;
update per_all_assignments_f paf1
set paf1.projected_assignment_end = projDates(i)
where paf1.period_of_placement_date_start = startDates(i)
and paf1.person_id = personIds(i)
and not exists (select null
from per_all_assignments_f paf2
where paf1.assignment_id
= paf2.assignment_id
and paf2.projected_assignment_end is not null);