The following lines contain the word 'select', 'insert', 'update' or 'delete':
select
compl_ca_detail_id
,compl_ca_header_id
--,action
,amount
,order_date
,due_date
,request_date
,complete_date
,category
--,type
,phase
,action_type
,payment_type
,object_version_number
,description
from ghr_compl_ca_details
where compl_ca_detail_id = p_compl_ca_detail_id;
select
compl_ca_detail_id
,compl_ca_header_id
--,action
,amount
,order_date
,due_date
,request_date
,complete_date
,category
--,type
,phase
,action_type
,payment_type
,object_version_number
,description
from ghr_compl_ca_details
where compl_ca_detail_id = p_compl_ca_detail_id
for update nowait;