375: CURSOR C_seq_number IS
376: SELECT rlm.seq_number,
377: rlm.groupbox_id,
378: rlm.user_name
379: FROM ghr_routing_list_members rlm
380: WHERE rlm.routing_list_id = p_2_routing_list_id
381: ORDER BY rlm.seq_number ASC;
382:
383:
2405: CURSOR cur_next_rout_seq IS
2406: SELECT rlm.seq_number,
2407: rlm.groupbox_id,
2408: rlm.user_name
2409: FROM ghr_routing_list_members rlm
2410: WHERE rlm.routing_list_id = p_i_routing_list_id
2411: AND rlm.seq_number > l_cur_seq_numb
2412: ORDER BY rlm.seq_number asc;
2413: