The following lines contain the word 'select', 'insert', 'update' or 'delete':
select transaction_document
from hr_api_transactions
where transaction_id = p_transaction_id;
select transaction_id
from hr_api_transactions
where ITEM_KEY = p_item_key
and ITEM_TYPE = p_item_type;
select pk1,pk2,pk3,pk4,pk5
from hr_api_transaction_steps
where transaction_id=p_transaction_id
and OBJECT_TYPE = p_object_type
and OBJECT_NAME = p_object_name;