The following lines contain the word 'select', 'insert', 'update' or 'delete':
select
resource_rule_id
,name
,business_group_id
,legislation_code
,eligibility_criteria_type
,eligibility_criteria_id
,pref_hierarchy_id
,rule_evaluation_order
,resource_type
,start_date
,end_date
,object_version_number
from hxc_resource_rules
where resource_rule_id = p_resource_rule_id;
select
resource_rule_id
,name
,business_group_id
,legislation_code
,eligibility_criteria_type
,eligibility_criteria_id
,pref_hierarchy_id
,rule_evaluation_order
,resource_type
,start_date
,end_date
,object_version_number
from hxc_resource_rules
where resource_rule_id = p_resource_rule_id
for update nowait;