APPS.GHR_PDH_BUS dependencies on GHR_POSITION_DESCRIPTIONS

Line 77: -- Validates that the position_description_id exists in the ghr_position_descriptions

73: -- |--------------------< chk_position_description_id >----------------------|
74: -- ---------------------------------------------------------------------------
75: --
76: -- Description:
77: -- Validates that the position_description_id exists in the ghr_position_descriptions
78: -- table
79: --
80: -- Pre-conditions:
81: -- None

Line 109: from ghr_position_descriptions gpd

105: l_api_updating boolean;
106: --
107: Cursor c_pos_desc_id is
108: select 1
109: from ghr_position_descriptions gpd
110: where gpd.position_description_id = p_position_description_id;
111: --
112: begin
113: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 188: ,p_position_description_id in ghr_position_descriptions.position_description_id%TYPE

184: -- Internal Table Handler Use Only.
185: --
186: procedure chk_groupbox_id
187: (p_pd_routing_history_id in ghr_pd_routing_history.pd_routing_history_id%TYPE
188: ,p_position_description_id in ghr_position_descriptions.position_description_id%TYPE
189: ,p_groupbox_id in ghr_pd_routing_history.groupbox_id%TYPE
190: ,p_object_version_number in ghr_pd_routing_history.object_version_number%TYPE
191: )is
192:

Line 201: ghr_position_descriptions gpd

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;
205: --