The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT pce.cagr_entitlement_item_id
FROM per_cagr_entitlements pce
WHERE pce.cagr_entitlement_item_id = p_cagr_entitlement_item_id;
select
cagr_entitlement_item_id
,item_name
,element_type_id
,input_value_id
,column_type
,column_size
,legislation_code
,cagr_api_id
,cagr_api_param_id
,business_group_id
,beneficial_rule
,category_name
,uom
,flex_value_set_id
,beneficial_formula_id
,object_version_number
,beneficial_rule_value_set_id
,multiple_entries_allowed_flag
,auto_create_entries_flag -- CEI Enh
,opt_id
from per_cagr_entitlement_items
where cagr_entitlement_item_id = p_cagr_entitlement_item_id;
select
cagr_entitlement_item_id
,item_name
,element_type_id
,input_value_id
,column_type
,column_size
,legislation_code
,cagr_api_id
,cagr_api_param_id
,business_group_id
,beneficial_rule
,category_name
,uom
,flex_value_set_id
,beneficial_formula_id
,object_version_number
,beneficial_rule_value_set_id
,multiple_entries_allowed_flag
,auto_create_entries_flag -- CEI Enh
,opt_id
from per_cagr_entitlement_items
where cagr_entitlement_item_id = p_cagr_entitlement_item_id
for update nowait;