The following lines contain the word 'select', 'insert', 'update' or 'delete':
select
compl_ca_header_id
,complaint_id
,ca_source
,last_compliance_report
,compliance_closed
,compl_docket_number
,appeal_docket_number
,pfe_docket_number
,pfe_received
,agency_brief_pfe_due
,agency_brief_pfe_date
,decision_pfe_date
,decision_pfe
,agency_recvd_pfe_decision
,agency_pfe_brief_forwd
,agency_notified_noncom
,comrep_noncom_req
,eeo_off_req_data_from_org
,org_forwd_data_to_eeo_off
,dec_implemented
,complaint_reinstated
,stage_complaint_reinstated
,object_version_number
from ghr_compl_ca_headers
where compl_ca_header_id = p_compl_ca_header_id;
select
compl_ca_header_id
,complaint_id
,ca_source
,last_compliance_report
,compliance_closed
,compl_docket_number
,appeal_docket_number
,pfe_docket_number
,pfe_received
,agency_brief_pfe_due
,agency_brief_pfe_date
,decision_pfe_date
,decision_pfe
,agency_recvd_pfe_decision
,agency_pfe_brief_forwd
,agency_notified_noncom
,comrep_noncom_req
,eeo_off_req_data_from_org
,org_forwd_data_to_eeo_off
,dec_implemented
,complaint_reinstated
,stage_complaint_reinstated
,object_version_number
from ghr_compl_ca_headers
where compl_ca_header_id = p_compl_ca_header_id
for update nowait;