[Home] [Help]
603:
604: CURSOR Cur_get_dep_steps(v_batch_id NUMBER, v_step_id NUMBER) IS
605: SELECT d.dep_step_id, d.dep_type, d.standard_delay, s.steprelease_type,
606: s.step_status,s.actual_cmplt_date,s.actual_start_date
607: FROM gme_batch_step_dependencies d, gme_batch_steps s
608: WHERE d.batchstep_id = v_step_id
609: AND s.batchstep_id = d.dep_step_id
610: AND s.batch_id = v_batch_id
611: AND s.batch_id = d.batch_id;
907:
908: -- Bug 13706812 - Use New select to help performance. Renamed original cursor.
909: CURSOR Cur_get_dep_steps_old IS
910: SELECT dep_step_id, dep_type, standard_delay
911: FROM gme_batch_step_dependencies
912: START WITH batchstep_id = p_batch_step_rec.batchstep_id
913: CONNECT BY batchstep_id = PRIOR dep_step_id;
914:
915: CURSOR Cur_get_dep_steps IS
913: CONNECT BY batchstep_id = PRIOR dep_step_id;
914:
915: CURSOR Cur_get_dep_steps IS
916: SELECT dep_step_id, dep_type, standard_delay
917: FROM (SELECT * FROM gme_batch_step_dependencies WHERE batch_id = p_batch_header_rec.batch_id) d,
918: (SELECT * FROM gme_batch_steps WHERE batch_id = p_batch_header_rec.batch_id) s,
919: (SELECT * FROM gme_batch_steps WHERE batch_id = p_batch_header_rec.batch_id) p
920: WHERE s.batchstep_id = d.batchstep_id
921: AND p.batchstep_id(+) = d.dep_step_id