The following lines contain the word 'select', 'insert', 'update' or 'delete':
select
communication_id
,communication_property_id
,object_type
,object_id
,status
,start_date
,end_date
,object_version_number
from irc_communications
where communication_id = p_communication_id;
select
communication_id
,communication_property_id
,object_type
,object_id
,status
,start_date
,end_date
,object_version_number
from irc_communications
where communication_id = p_communication_id
for update nowait;