The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT ELTT.ELEMENT_NAME
FROM PAY_ELEMENT_TYPES_F ELT1
,PAY_ELEMENT_TYPES_F_TL ELTT
,HXT_PAY_ELEMENT_TYPES_F_DDF_V ELTV1
WHERE ELTV1.ELEMENT_TYPE_ID = P_ELT_PRIOR_PREM_ID
AND ELTV1.EFFECTIVE_START_DATE <= P_EFFECTIVE_START_DATE
AND ELTV1.EFFECTIVE_END_DATE >= P_EFFECTIVE_END_DATE
AND ELTV1.ELEMENT_TYPE_ID = ELT1.ELEMENT_TYPE_ID
AND ELT1.EFFECTIVE_START_DATE <= P_EFFECTIVE_START_DATE
AND ELT1.EFFECTIVE_END_DATE >= P_EFFECTIVE_END_DATE
AND ELT1.element_type_id = eltt.element_type_id
AND ELTV1.element_type_id = elt1.element_type_id
and eltt.language = userenv('LANG')
and (eltv1.hxt_premium_type = 'FACTOR'
AND eltv1.hxt_earning_category = 'OVT'
or eltv1.hxt_earning_category NOT IN ('REG', 'OVT', 'ABS'));
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 ELTV.ELEMENT_TYPE_ID = P_ELT_EARNED_PREM_ID
AND ELTV.EFFECTIVE_START_DATE <= P_EFFECTIVE_START_DATE
AND ELTV.EFFECTIVE_END_DATE >= P_EFFECTIVE_END_DATE
AND ELTV.ELEMENT_TYPE_ID = ELT.ELEMENT_TYPE_ID
AND ELT.EFFECTIVE_START_DATE <= P_EFFECTIVE_START_DATE
AND ELT.EFFECTIVE_END_DATE >= P_EFFECTIVE_END_DATE
AND ELT.element_type_id = eltt.element_type_id
AND ELTV.element_type_id = elt.element_type_id
and eltt.language = userenv('LANG')
and (eltv.hxt_premium_type = 'FACTOR'
AND eltv.hxt_earning_category = 'OVT'
or eltv.hxt_earning_category NOT IN ('REG', 'OVT', 'ABS'));