The following lines contain the word 'select', 'insert', 'update' or 'delete':
select
time_building_block_id
,type
,measure
,unit_of_measure
,start_time
,stop_time
,parent_building_block_id
,parent_building_block_ovn
,scope
,object_version_number
,approval_status
,resource_id
,resource_type
,approval_style_id
,date_from
,date_to
,comment_text
,application_set_id
,data_set_id
,translation_display_key
from hxc_time_building_blocks
where time_building_block_id = p_time_building_block_id;
select
time_building_block_id
,type
,measure
,unit_of_measure
,start_time
,stop_time
,parent_building_block_id
,parent_building_block_ovn
,scope
,object_version_number
,approval_status
,resource_id
,resource_type
,approval_style_id
,date_from
,date_to
,comment_text
,application_set_id
,data_set_id
,translation_display_key
from hxc_time_building_blocks
where time_building_block_id = p_time_building_block_id
and object_version_number = (select max(object_version_number)
from hxc_time_building_blocks
where time_building_block_id = p_time_building_block_id)
for update nowait;