DBA Data[Home] [Help]

APPS.GHR_PRH_BUS dependencies on GHR_ROUTING_LIST_MEMBERS

Line 447: -- 'GHR_ROUTING_LIST_MEMBERS for the specific routing_list

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

Line 483: from ghr_routing_list_members rlm

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