The following lines contain the word 'select', 'insert', 'update' or 'delete':
select
successee_detail_id
,business_group_id
,successee_type
,successee_id
,display_permissions
,max_plans
,allow_npws
,allow_applicants
,allow_override_search
,key_entity
,risk_of_loss
,impact_of_loss
,plan_readiness_rule
,max_successors
,object_version_number
from per_sp_successee_details
where successee_detail_id = p_successee_detail_id;
select
successee_detail_id
,business_group_id
,successee_type
,successee_id
,display_permissions
,max_plans
,allow_npws
,allow_applicants
,allow_override_search
,key_entity
,risk_of_loss
,impact_of_loss
,plan_readiness_rule
,max_successors
,object_version_number
from per_sp_successee_details
where successee_detail_id = p_successee_detail_id
for update nowait;