DBA Data[Home] [Help]

APPS.GHR_PDH_BUS dependencies on GHR_ROUTING_LIST_MEMBERS

Line 446: -- 'GHR_ROUTING_LIST_MEMBERS for the specific routing_list

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

Line 482: from ghr_routing_list_members rlm

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