The following lines contain the word 'select', 'insert', 'update' or 'delete':
select
resource_usage_id
,supplied_resource_id
,activity_version_id
,object_version_number
,required_flag
,start_date
,comments
,end_date
,quantity
,resource_type
,role_to_play
,usage_reason
,rud_information_category
,rud_information1
,rud_information2
,rud_information3
,rud_information4
,rud_information5
,rud_information6
,rud_information7
,rud_information8
,rud_information9
,rud_information10
,rud_information11
,rud_information12
,rud_information13
,rud_information14
,rud_information15
,rud_information16
,rud_information17
,rud_information18
,rud_information19
,rud_information20
,offering_id
from ota_resource_usages
where resource_usage_id = p_resource_usage_id;
select resource_usage_id,
supplied_resource_id,
activity_version_id,
object_version_number,
required_flag,
start_date,
comments,
end_date,
quantity,
resource_type,
role_to_play,
usage_reason,
rud_information_category,
rud_information1,
rud_information2,
rud_information3,
rud_information4,
rud_information5,
rud_information6,
rud_information7,
rud_information8,
rud_information9,
rud_information10,
rud_information11,
rud_information12,
rud_information13,
rud_information14,
rud_information15,
rud_information16,
rud_information17,
rud_information18,
rud_information19,
rud_information20,
offering_id
from ota_resource_usages
where resource_usage_id = p_resource_usage_id
for update nowait;