1025: AND completed_ind = v_completed
1026: AND (v_completed = 1 OR sequence_dependent_ind = 0);
1027:
1028: --Bug#5231180 Begin added the following cursors
1029: CURSOR cur_get_rsrc (v_rsrc cr_rsrc_mst.resources%TYPE)
1030: IS
1031: SELECT max_capacity, capacity_um
1032: FROM cr_rsrc_mst
1033: WHERE resources = v_rsrc
1028: --Bug#5231180 Begin added the following cursors
1029: CURSOR cur_get_rsrc (v_rsrc cr_rsrc_mst.resources%TYPE)
1030: IS
1031: SELECT max_capacity, capacity_um
1032: FROM cr_rsrc_mst
1033: WHERE resources = v_rsrc
1034: AND capacity_constraint = 1;
1035:
1036: CURSOR cur_get_charge_rsrc(v_step_id gme_batch_steps.batchstep_id%TYPE, v_rsrc cr_rsrc_mst.resources%TYPE)
1032: FROM cr_rsrc_mst
1033: WHERE resources = v_rsrc
1034: AND capacity_constraint = 1;
1035:
1036: CURSOR cur_get_charge_rsrc(v_step_id gme_batch_steps.batchstep_id%TYPE, v_rsrc cr_rsrc_mst.resources%TYPE)
1037: IS
1038: SELECT 1
1039: FROM DUAL
1040: WHERE EXISTS (SELECT 1