The following lines contain the word 'select', 'insert', 'update' or 'delete':
select payroll_name
into c_payroll_name
from pay_payrolls_x
where payroll_id = p_payroll_id;
select ptp.period_name
into c_time_period_name
from per_time_periods ptp
where ptp.time_period_id = p_time_period_id;
select pcs.consolidation_set_name
into c_consolidation_set_name
from pay_consolidation_sets pcs
where pcs.consolidation_set_id = p_consolidation_set;