158: WHERE batch_id = l_batch_step.batch_id
159: AND batchstep_id = l_batch_step.batchstep_id;
160:
161: -- 5. Delete all the chanrges
162: DELETE gme_batch_step_charges
163: WHERE batch_id = l_batch_step.batch_id
164: AND batchstep_id = l_batch_step.batchstep_id;
165:
166: -- Navin: END Changed the logic --
458: SELECT 1
459: FROM DUAL
460: WHERE EXISTS (
461: SELECT 1
462: FROM gme_batch_step_charges
463: WHERE resources = v_resources
464: AND batchstep_id = v_batchstep_id);
465:
466: l_cur_is_charge_associated cur_is_charge_associated%ROWTYPE;