APPS.GME_REVERT_STEP_PVT dependencies on STANDARD

Line 42: SELECT batchstep_no, s.step_status,d.dep_type,d.standard_delay, s.steprelease_type

38: l_material_details_tab gme_common_pvt.material_details_tab ;
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