The following lines contain the word 'select', 'insert', 'update' or 'delete':
select ppos.person_id
from per_periods_of_service ppos
where period_of_service_id = c_period_of_service_id;
select paaf.assignment_id
from per_all_assignments_f paaf
where paaf.person_id = c_person_id and
c_effective_date between effective_start_date
and effective_end_date;
select assignment_id
from per_assignments_f
where period_of_service_id = p_period_of_service_id;
SELECT paye_details_id,
effective_start_date,
effective_end_date
FROM pay_ie_paye_details_f
WHERE assignment_id = p_assignment_id AND
p_final_process_date BETWEEN effective_start_date
AND effective_end_date
ORDER BY effective_start_date;
SELECT prsi_details_id, effective_start_date, effective_end_date
FROM pay_ie_prsi_details_f
WHERE assignment_id = p_assignment_id AND
p_final_process_date BETWEEN effective_start_date
AND effective_end_date
ORDER BY effective_start_date;
UPDATE pay_ie_prsi_details_f
SET effective_end_date = p_final_process_date
WHERE prsi_details_id = l_prsi_detail_id AND
p_final_process_date BETWEEN effective_start_date
AND effective_end_date;
DELETE FROM pay_ie_prsi_details_f
WHERE prsi_details_id = l_prsi_detail_id AND
effective_start_date > p_final_process_date;
UPDATE pay_ie_paye_details_f
SET effective_end_date = p_final_process_date
WHERE paye_details_id = l_paye_detail_id AND
p_final_process_date BETWEEN effective_start_date
AND effective_end_date;
DELETE FROM pay_ie_paye_details_f
WHERE paye_details_id = l_paye_detail_id AND
effective_start_date > p_final_process_date;
SELECT max(effective_end_date)
FROM pay_ie_paye_details_f
WHERE assignment_id = p_assignment_id;
UPDATE pay_ie_paye_details_f
SET effective_end_date = TO_CHAR(hr_general.end_of_time, 'DD-MON-YYYY')
WHERE assignment_id = asg_id.assignment_id AND
l_final_process_date BETWEEN effective_start_date
AND effective_end_date;
UPDATE pay_ie_prsi_details_f
SET effective_end_date = TO_CHAR(hr_general.end_of_time, 'DD-MON-YYYY')
WHERE assignment_id = asg_id.assignment_id AND
l_final_process_date BETWEEN effective_start_date
AND effective_end_date;