DBA Data[Home] [Help]

APPS.GHR_PRH_BUS dependencies on GHR_GROUPBOXES

Line 167: -- Validates that the group_box_id exists in the table GHR_GROUPBOXES

163: -- ----------------------------------------------------------------------------
164: -- |-------------------------------------------------------|
165: -- ----------------------------------------------------------------------------
166: -- Description:
167: -- Validates that the group_box_id exists in the table GHR_GROUPBOXES
168: -- for a specific routing_group
169: --
170: -- Pre-conditions:
171: --

Line 203: from ghr_groupboxes gbx,

199: l_api_updating boolean;l_grp_box Number;
200: --
201: Cursor c_gpbox_id is
202: select 1
203: from ghr_groupboxes gbx,
204: ghr_pa_requests par
205: where par.pa_request_id = p_pa_request_id
206: and gbx.routing_group_id = par.routing_group_id
207: and gbx.groupbox_id = p_groupbox_id;