DBA Data[Home] [Help]

APPS.GHR_PDI_API dependencies on GHR_ROUTING_LIST_MEMBERS

Line 124: from ghr_routing_list_members rlm

120: Cursor C_seq_number is
121: select rlm.seq_number,
122: rlm.groupbox_id,
123: rlm.user_name
124: from ghr_routing_list_members rlm
125: where rlm.routing_list_id = p_2_routing_list_id
126: order by rlm.seq_number asc;
127: Cursor c_history_exists is
128: select 1

Line 703: from ghr_routing_list_members rlm

699: cursor cur_next_rout_seq is
700: select rlm.seq_number,
701: rlm.groupbox_id,
702: rlm.user_name
703: from ghr_routing_list_members rlm
704: where rlm.routing_list_id = p_i_routing_list_id
705: and rlm.seq_number > l_cur_seq_numb
706: order by rlm.seq_number asc;
707: cursor c_history_exists is