The following lines contain the word 'select', 'insert', 'update' or 'delete':
select
batch_id
,business_group_id
,batch_name
,batch_status
,action_if_exists
,batch_reference
,batch_source
,batch_type
,comments
,date_effective_changes
,purge_after_transfer
,reject_if_future_changes
,reject_if_results_exists
,purge_after_rollback
,REJECT_ENTRY_NOT_REMOVED
,ROLLBACK_ENTRY_UPDATES
,object_version_number
from pay_batch_headers
where batch_id = p_batch_id;
select
batch_id
,business_group_id
,batch_name
,batch_status
,action_if_exists
,batch_reference
,batch_source
,batch_type
,comments
,date_effective_changes
,purge_after_transfer
,reject_if_future_changes
,reject_if_results_exists
,purge_after_rollback
,REJECT_ENTRY_NOT_REMOVED
,ROLLBACK_ENTRY_UPDATES
,object_version_number
from pay_batch_headers
where batch_id = p_batch_id
for update nowait;
,p_ROLLBACK_ENTRY_UPDATES in varchar2
,p_object_version_number in number
)
Return g_rec_type is
--
l_rec g_rec_type;
l_rec.ROLLBACK_ENTRY_UPDATES := p_ROLLBACK_ENTRY_UPDATES;