1141: AND completed_ind = v_completed
1142: AND (v_completed = 1 OR sequence_dependent_ind = 0);
1143:
1144: --Bug#5231180 Begin added the following cursors
1145: CURSOR cur_get_rsrc (v_rsrc cr_rsrc_mst.resources%TYPE)
1146: IS
1147: SELECT max_capacity, capacity_um
1148: FROM cr_rsrc_mst
1149: WHERE resources = v_rsrc
1144: --Bug#5231180 Begin added the following cursors
1145: CURSOR cur_get_rsrc (v_rsrc cr_rsrc_mst.resources%TYPE)
1146: IS
1147: SELECT max_capacity, capacity_um
1148: FROM cr_rsrc_mst
1149: WHERE resources = v_rsrc
1150: AND capacity_constraint = 1;
1151:
1152: CURSOR cur_get_charge_rsrc(v_step_id gme_batch_steps.batchstep_id%TYPE, v_rsrc cr_rsrc_mst.resources%TYPE)
1148: FROM cr_rsrc_mst
1149: WHERE resources = v_rsrc
1150: AND capacity_constraint = 1;
1151:
1152: CURSOR cur_get_charge_rsrc(v_step_id gme_batch_steps.batchstep_id%TYPE, v_rsrc cr_rsrc_mst.resources%TYPE)
1153: IS
1154: SELECT 1
1155: FROM DUAL
1156: WHERE EXISTS (SELECT 1