The following lines contain the word 'select', 'insert', 'update' or 'delete':
select paf.DEFAULT_PAYMENT_METHOD_ID
from pay_payrolls_f paf
where paf.payroll_id = p_payroll_id
and p_effective_date between paf.effective_start_date and paf.effective_end_date;
select ppm.external_account_id
from pay_personal_payment_methods_f ppm
where ppm.personal_payment_method_id=p_personal_method_id
and p_effective_date between ppm.effective_start_date and ppm.effective_end_date;
select paf.DEFAULT_PAYMENT_METHOD_ID
from pay_payrolls_f paf
where paf.payroll_id = p_payroll_id
and p_effective_date between paf.effective_start_date and paf.effective_end_date;
select ppm.external_account_id into l_account_id
from pay_personal_payment_methods_f ppm
where ppm.personal_payment_method_id=l_personal_method_id
and p_effective_date between ppm.effective_start_date and ppm.effective_end_date;
select ppm.external_account_id
from pay_personal_payment_methods_f ppm
where ppm.personal_payment_method_id=p_personal_method_id
and p_effective_date between ppm.effective_start_date and ppm.effective_end_date;
SELECT legislative_parameters
FROM pay_payroll_actions
WHERE payroll_action_id = p_pact_id;