378: AND p_batch_step_dependencies.dep_step_id IS NOT NULL THEN
379: -- Bharati Satpute Selecting batchstep_no for message.
380: SELECT batchstep_no
381: INTO x_batchstep_no
382: FROM gme_batch_steps
383: WHERE batchstep_id = p_batch_step_dependencies.batchstep_id
384: AND batch_id = p_batch_step_dependencies.batch_id;
385:
386: SELECT 1
491: AND p_batch_step_dependencies.dep_step_id IS NOT NULL THEN
492: -- Bharati Satpute Selecting batchstep_no for message.
493: SELECT batchstep_no
494: INTO x_batchstep_no
495: FROM gme_batch_steps
496: WHERE batchstep_id = p_batch_step_dependencies.batchstep_id
497: AND batch_id = p_batch_step_dependencies.batch_id;
498:
499: SELECT 1
650: AND p_batch_step_dependencies.dep_step_id IS NOT NULL THEN
651: -- Bharati Satpute Selecting batchstep_no for message.
652: SELECT batchstep_no
653: INTO x_batchstep_no
654: FROM gme_batch_steps
655: WHERE batchstep_id = p_batch_step_dependencies.batchstep_id
656: AND batch_id = p_batch_step_dependencies.batch_id;
657:
658: SELECT 1