The following lines contain the word 'select', 'insert', 'update' or 'delete':
select
compl_adr_id
,complaint_id
,stage
,start_date
,end_date
,adr_resource
,technique
,outcome
,adr_offered
,date_accepted
,object_version_number
from ghr_compl_adrs
where compl_adr_id = p_compl_adr_id;
select
compl_adr_id
,complaint_id
,stage
,start_date
,end_date
,adr_resource
,technique
,outcome
,adr_offered
,date_accepted
,object_version_number
from ghr_compl_adrs
where compl_adr_id = p_compl_adr_id
for update nowait;