The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT approval_style_id
FROM hxc_approval_styles
WHERE name = p_name;
SELECT ff.formula_id
FROM ff_formulas_f ff
WHERE ff.formula_name = p_formula_name;
SELECT hac.approval_comp_id
, hac.object_version_number
, DECODE( NVL(hac.last_updated_by,-1), 1, 'SEED', 'CUSTOM')
INTO l_approval_comp_id
, l_ovn
, l_owner
FROM hxc_approval_comps hac
, hxc_approval_styles has
WHERE has.name = P_AS_NAME
AND hac.approval_style_id = has.approval_style_id
AND hac.time_recipient_id = l_time_recipient_id
AND hac.approval_mechanism = p_approval_mechanism;