113: CURSOR cur_get_prec_steps (v_batch_id NUMBER, v_batchstep_id NUMBER)
114: IS
115: SELECT s.batchstep_id, d.dep_type, d.standard_delay
116: ,s.step_status
117: FROM gme_batch_step_dependencies d, gme_batch_steps s
118: WHERE d.batchstep_id = v_batchstep_id
119: AND s.batchstep_id = d.dep_step_id
120: AND s.batch_id = v_batch_id
121: AND d.batch_id = s.batch_id
123:
124: CURSOR cur_get_succ_steps (v_batch_id NUMBER, v_batchstep_id NUMBER)
125: IS
126: SELECT d.batchstep_id, d.dep_type, d.standard_delay, s.step_status
127: FROM gme_batch_step_dependencies d, gme_batch_steps s
128: WHERE d.batchstep_id = s.batchstep_id
129: AND d.dep_step_id = v_batchstep_id
130: AND s.batch_id = v_batch_id
131: AND d.batch_id = s.batch_id
144: SELECT MAX ( DECODE (d.dep_type
145: ,1, s.plan_start_date
146: ,0, s.plan_cmplt_date)
147: + d.standard_delay / 24) max_date
148: FROM gme_batch_step_dependencies d, gme_batch_steps s
149: WHERE d.batchstep_id = v_batchstep_id
150: AND s.batchstep_id = d.dep_step_id
151: AND s.batch_id = v_batch_id
152: AND d.batch_id = s.batch_id;