The following lines contain the word 'select', 'insert', 'update' or 'delete':
select overriding_dd_date
from pay_payroll_actions
where payroll_action_id = p_payroll_action_id;
select PMETH_INFORMATION4
from PAY_ORG_PAYMENT_METHODS_F
where ORG_PAYMENT_METHOD_ID = p_org_payment_method_id;
EXECUTE IMMEDIATE 'select '||l_func_name||'(:1,:2,:3,:4,:5,:6,:7,:8,:9) from dual'
INTO l_return_value
USING p_effective_date ,
p_identifier_name,
p_payroll_action_id,
p_payment_type_id,
p_org_payment_method_id,
p_personal_payment_method_id,
p_assignment_action_id,
p_pre_payment_id,
p_delimiter_string ;