139: ) IS
140:
141: CURSOR c_group_id IS
142: SELECT group_id
143: FROM jtf_rs_groups_b
144: WHERE group_id = p_group_id;
145:
146: CURSOR c_group_number IS
147: SELECT group_id
144: WHERE group_id = p_group_id;
145:
146: CURSOR c_group_number IS
147: SELECT group_id
148: FROM jtf_rs_groups_b
149: WHERE group_number = p_group_number;
150:
151:
152: BEGIN