APPS.GME_REVERT_STEP_PVT dependencies on GME_BATCH_STEP_DEPENDENCIES

Line 43: FROM gme_batch_step_dependencies d, gme_batch_steps s

39: /* Bug 2685645 added batch_id as parama and used in where clause */
40: CURSOR cur_dep_steps (v_batchstep_id NUMBER,
41: v_batch_id NUMBER) IS
42: SELECT batchstep_no, s.step_status,d.dep_type,d.standard_delay, s.steprelease_type
43: FROM gme_batch_step_dependencies d, gme_batch_steps s
44: WHERE d.batchstep_id = s.batchstep_id AND
45: d.dep_step_id = v_batchstep_id AND
46: s.batch_id = v_batch_id AND
47: d.batch_id = s.batch_id;