The following lines contain the word 'select', 'insert', 'update' or 'delete':
select
transaction_value_id,
transaction_step_id,
datatype,
name,
varchar2_value,
number_value,
date_value,
original_varchar2_value,
original_number_value,
original_date_value
from hr_api_transaction_values
where transaction_value_id = p_transaction_value_id;
select transaction_value_id,
transaction_step_id,
datatype,
name,
varchar2_value,
number_value,
date_value,
original_varchar2_value,
original_number_value,
original_date_value
from hr_api_transaction_values
where transaction_value_id = p_transaction_value_id
for update nowait;