The following lines contain the word 'select', 'insert', 'update' or 'delete':
select name
into pep_name
from hxt_prem_eligblty_policies
where id = pep_id;
select name
into pip_name
from hxt_prem_interact_policies
where id = pip_id;
select name
into egt_type
from hxt_earn_group_types
where id = egt_id;
SELECT ELTT.ELEMENT_NAME
FROM PAY_ELEMENT_TYPES_F ELT
,PAY_ELEMENT_TYPES_F_TL ELTT
,HXT_PAY_ELEMENT_TYPES_F_DDF_V ELTV
WHERE ELT.ELEMENT_TYPE_ID = arg_ELEMENT_TYPE_ID
AND ELTT.ELEMENT_TYPE_ID = ELT.ELEMENT_TYPE_ID
AND ELTV.ELEMENT_TYPE_ID = ELT.ELEMENT_TYPE_ID
AND elt.effective_start_date <= arg_EFFECTIVE_START_DATE
and elt.effective_end_date >= arg_EFFECTIVE_END_DATE
AND eltt.language = userenv('LANG')
AND HXT_EARNING_CATEGORY IN ('OVT', 'REG');