The following lines contain the word 'select', 'insert', 'update' or 'delete':
select
reallocation_id
,position_id
,pool_id
,reallocation_amt
,reserved_amt
,object_version_number
,txn_detail_id
,transaction_type
,budget_detail_id
,budget_period_id
,entity_id
,start_date
,end_date
from pqh_bdgt_pool_realloctions
where reallocation_id = p_reallocation_id;
select
reallocation_id
,position_id
,pool_id
,reallocation_amt
,reserved_amt
,object_version_number
,txn_detail_id
,transaction_type
,budget_detail_id
,budget_period_id
,entity_id
,start_date
,end_date
from pqh_bdgt_pool_realloctions
where reallocation_id = p_reallocation_id
for update nowait;