APPS.GHR_PRH_BUS dependencies on GHR_PA_REQUESTS

Line 80: -- Validates that the pa_request_id exists in the ghr_pa_requests_table

76: -- |-----------------------< chk_pa_request_id >--------------------------|
77: -- ---------------------------------------------------------------------------
78: --
79: -- Description:
80: -- Validates that the pa_request_id exists in the ghr_pa_requests_table
81: --
82: -- Pre-conditions:
83: -- None
84: --

Line 111: from ghr_pa_requests par

107: l_api_updating boolean;
108: --
109: Cursor c_pa_req_id is
110: select 1
111: from ghr_pa_requests par
112: where par.pa_request_id = p_pa_request_id;
113: --
114: begin
115: l_proc := g_package||'chk_pa_request_id';

Line 191: ,p_pa_request_id in ghr_pa_requests.pa_request_id%TYPE

187: -- Internal Table Handler Use Only.
188: --
189: procedure chk_groupbox_id
190: (p_pa_routing_history_id in ghr_pa_routing_history.pa_routing_history_id%TYPE
191: ,p_pa_request_id in ghr_pa_requests.pa_request_id%TYPE
192: ,p_groupbox_id in ghr_pa_routing_history.groupbox_id%TYPE
193: ,p_object_version_number in ghr_pa_routing_history.object_version_number%TYPE
194: )is
195:

Line 204: ghr_pa_requests par

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