The following lines contain the word 'select', 'insert', 'update' or 'delete':
select batch_id, batchstep_id
from gme_batch_steps
where ((GMO_CONSTANTS_GRP.ENTITY_BATCH = P_ENTITY_NAME AND batch_id = p_entity_key) OR
(GMO_CONSTANTS_GRP.ENTITY_OPERATION = P_ENTITY_NAME AND batchstep_id = p_entity_key));
select batchstep_activity_id
from gme_batch_step_activities
where
batchstep_id = l_batchstep_id
AND batch_id = l_batch_id;
select batchstep_resource_id
from gme_batch_step_resources gbsr
where batchstep_activity_id = l_batchstep_activity_id
AND batch_id = l_batch_id AND batchstep_id = l_batchstep_id
;
select material_detail_id
from gme_material_details
where batch_id = p_entity_key;
select material_detail_id
from gme_batch_step_items
where batchstep_id = l_batchstep_id
AND batch_id = l_batch_id;
SELECT Dispense_id
from gmo_material_dispenses
WHERE material_status = 'DISPENSD'
and material_detail_id = l_material_detail_id;
SELECT unDispense_id
from gmo_material_undispenses
WHERE material_status = 'DISPENSD'
and material_detail_id = l_material_detail_id;
select count(*) into l_ncm_count
from qa_results_v
where PROCESS_BATCH_ID = p_entity_key
and NONCONFORMANCE_STATUS <> 'CLOSED';
select count(*) into l_ncm_count
from qa_results_v
where PROCESS_BATCHSTEP_ID = p_entity_key
and NONCONFORMANCE_STATUS <> 'CLOSED';