DBA Data[Home] [Help]

APPS.GHR_PRH_BUS dependencies on GHR_ROUTING_LIST_MEMBERS

Line 444: -- 'GHR_ROUTING_LIST_MEMBERS for the specific routing_list

440: -- |-------------------------------------------------------|
441: -- ----------------------------------------------------------------------------
442: -- Description:
443: -- Validates that the routing_seq_number exists in the table
444: -- 'GHR_ROUTING_LIST_MEMBERS for the specific routing_list
445: --
446: -- Pre-conditions:
447: --
448: --

Line 480: from ghr_routing_list_members rlm

476: l_api_updating boolean;
477: --
478: Cursor c_seq_num is
479: select 1
480: from ghr_routing_list_members rlm
481: where rlm.routing_list_id = p_routing_list_id
482: and rlm.seq_number = p_routing_seq_number;
483:
484: begin