APPS.GME_RESCHEDULE_STEP_PVT dependencies on GME_BATCH_STEP_DEPENDENCIES

Line 120: FROM gme_batch_step_dependencies d, gme_batch_steps s

116: CURSOR cur_get_prec_steps (v_batch_id NUMBER, v_batchstep_id NUMBER)
117: IS
118: SELECT s.batchstep_id, d.dep_type, d.standard_delay
119: ,s.step_status
120: FROM gme_batch_step_dependencies d, gme_batch_steps s
121: WHERE d.batchstep_id = v_batchstep_id
122: AND s.batchstep_id = d.dep_step_id
123: AND s.batch_id = v_batch_id
124: AND d.batch_id = s.batch_id

Line 132: FROM gme_batch_step_dependencies d, gme_batch_steps s

128: -- Bug 11925400 - Add step status check to the where clause.
129: CURSOR cur_get_succ_steps (v_batch_id NUMBER, v_batchstep_id NUMBER)
130: IS
131: SELECT d.batchstep_id, d.dep_type, d.standard_delay, s.step_status
132: FROM gme_batch_step_dependencies d, gme_batch_steps s
133: WHERE d.batchstep_id = s.batchstep_id
134: AND d.dep_step_id = v_batchstep_id
135: AND s.batch_id = v_batch_id
136: AND d.batch_id = s.batch_id

Line 154: FROM gme_batch_step_dependencies d, gme_batch_steps s

150: SELECT MAX ( DECODE (d.dep_type
151: ,1, s.plan_start_date
152: ,0, s.plan_cmplt_date)
153: + d.standard_delay / 24) max_date
154: FROM gme_batch_step_dependencies d, gme_batch_steps s
155: WHERE d.batchstep_id = v_batchstep_id
156: AND s.batchstep_id = d.dep_step_id
157: AND s.batch_id = v_batch_id
158: AND d.batch_id = s.batch_id;