APPS.GME_COMPLETE_BATCH_STEP_PVT dependencies on GME_BATCH_STEP_DEPENDENCIES

Line 549: FROM gme_batch_step_dependencies d, gme_batch_steps s

545:
546: CURSOR Cur_get_dep_steps(v_batch_id NUMBER, v_step_id NUMBER) IS
547: SELECT d.dep_step_id, d.dep_type, d.standard_delay, s.steprelease_type,
548: s.step_status,s.actual_cmplt_date,s.actual_start_date
549: FROM gme_batch_step_dependencies d, gme_batch_steps s
550: WHERE d.batchstep_id = v_step_id
551: AND s.batchstep_id = d.dep_step_id
552: AND s.batch_id = v_batch_id
553: AND s.batch_id = d.batch_id;

Line 833: FROM gme_batch_step_dependencies

829: l_api_name CONSTANT VARCHAR2 (30) := 'validate_step_cmplt_date';
830:
831: CURSOR Cur_get_dep_steps IS
832: SELECT dep_step_id, dep_type, standard_delay
833: FROM gme_batch_step_dependencies
834: START WITH batchstep_id = p_batch_step_rec.batchstep_id
835: CONNECT BY batchstep_id = PRIOR dep_step_id;
836:
837: BATCH_STEP_FETCH_ERROR EXCEPTION;