APPS.GMD_AUTO_STEP_CALC dependencies on GME_BATCH_STEP_DEPENDENCIES

Line 94: FROM gme_batch_step_dependencies d, gme_batch_steps s

90: AND routingstep_no = V_step;
91:
92: CURSOR Cur_get_pm_dep_steps (V_step_id NUMBER) IS
93: SELECT batchstep_no, transfer_percent, step_status
94: FROM gme_batch_step_dependencies d, gme_batch_steps s
95: WHERE d.batch_id = P_parent_id
96: AND d.batchstep_id = V_step_id
97: AND s.batchstep_id = d.dep_step_id
98: AND s.batch_id = d.batch_id;

Line 573: FROM gme_batch_step_dependencies d

569: WHERE batch_id = P_parent_id;
570:
571: CURSOR Cur_get_pm_steps (V_step_id NUMBER) IS
572: SELECT d.dep_step_id, max(level)
573: FROM gme_batch_step_dependencies d
574: WHERE d.batch_id = P_parent_id
575: START WITH ((d.batch_id = P_parent_id) AND
576: ((v_step_id IS NULL) OR (batchstep_id = v_step_id)))
577: CONNECT BY d.batch_id = prior d.batch_id

Line 600: FROM gme_batch_step_dependencies

596: FROM gme_batch_steps s
597: WHERE s.batch_id = P_parent_id
598: AND s.batchstep_id NOT IN
599: (SELECT dep_step_id
600: FROM gme_batch_step_dependencies
601: WHERE batch_id = P_parent_id);
602:
603: CURSOR Cur_get_pm_process_uom (V_batchstep_no NUMBER) IS
604: SELECT STEP_QTY_UM