The following lines contain the word 'select', 'insert', 'update' or 'delete':
select
setup_sub_task_code
,setup_task_code
,setup_sub_task_sequence
,setup_sub_task_status
,setup_sub_task_type
,setup_sub_task_data_pump_link
,setup_sub_task_action
,setup_sub_task_creation_date
,setup_sub_task_last_mod_date
,legislation_code
,object_version_number
from per_ri_setup_sub_tasks
where setup_sub_task_code = p_setup_sub_task_code;
select
setup_sub_task_code
,setup_task_code
,setup_sub_task_sequence
,setup_sub_task_status
,setup_sub_task_type
,setup_sub_task_data_pump_link
,setup_sub_task_action
,setup_sub_task_creation_date
,setup_sub_task_last_mod_date
,legislation_code
,object_version_number
from per_ri_setup_sub_tasks
where setup_sub_task_code = p_setup_sub_task_code
for update nowait;