DBA Data[Home] [Help]

APPS.GHR_PDH_BUS dependencies on GHR_GROUPBOXES

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

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

Line 200: from ghr_groupboxes gbx,

196: l_api_updating boolean;
197: --
198: Cursor c_gpbox_id is
199: select 1
200: from ghr_groupboxes gbx,
201: ghr_position_descriptions gpd
202: where gpd.position_description_id = p_position_description_id
203: and gbx.routing_group_id = gpd.routing_group_id
204: and gbx.groupbox_id = p_groupbox_id;