The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT 1
FROM gme_batch_steps
WHERE batchstep_id = v_rec_id;
/* Bug 3681718 - Only update flex field columns in x_ OUT parameter. */
x_batch_step.attribute_category :=
l_batch_step_row.attribute_category;
SELECT 1
FROM gme_batch_step_activities
WHERE batchstep_activity_id = v_rec_id;
/* Bug 3681718 - Only update flex field columns in x_ OUT parameter. */
x_step_activities.attribute_category :=
l_step_activities_row.attribute_category;
SELECT 1
FROM gme_batch_step_resources
WHERE batchstep_resource_id = v_rec_id;
/* Bug 3681718 - Only update flex field columns in x_ OUT parameter. */
x_step_resources.attribute_category :=
l_step_resource_row.attribute_category;
SELECT 1
FROM gme_resource_txns
WHERE poc_trans_id = v_rec_id;
SELECT 1
FROM gme_process_parameters
WHERE process_param_id = v_rec_id;
/* Only update flex field columns in x_out parameter. */
x_process_param_rec.attribute_category :=
l_process_param_rec.attribute_category;