The following lines contain the word 'select', 'insert', 'update' or 'delete':
select hwm_stage into l_hwm_stage
from hz_imp_work_units
where batch_id = P_BATCH_ID
and orig_system = P_OS
and from_orig_system_ref = P_FROM_OSR;
/* Update status to Complete for the work unit that just finished */
UPDATE HZ_IMP_WORK_UNITS
SET STATUS = 'C'
WHERE BATCH_ID = P_BATCH_ID
AND FROM_ORIG_SYSTEM_REF = P_FROM_OSR;
UPDATE hz_imp_batch_summary
SET import_status = 'ERROR'
WHERE batch_id = P_BATCH_ID;
UPDATE hz_imp_batch_details
SET import_status = 'ERROR'
WHERE batch_id = P_BATCH_ID
AND run_number = (SELECT max(run_number)
FROM hz_imp_batch_details
WHERE batch_id = P_BATCH_ID);