APPS.GHR_HISTORY_CASCADE dependencies on GHR_PA_REQUESTS

Line 224: where pa_request_id = (select min(pa_request_id) from ghr_pa_requests

220: (select min(pa_history_id) from ghr_pa_history where pa_request_id = pah.pa_request_id
221: and nature_of_action_id = pah.nature_of_action_id)) or
222: (altered_pa_request_id is not null and c_root_hist_id <
223: (select min(pa_history_id) from ghr_pa_history pah2
224: where pa_request_id = (select min(pa_request_id) from ghr_pa_requests
225: connect by pa_request_id = prior altered_pa_request_id
226: start with pa_request_id = pah.pa_request_id) and
227: nature_of_action_id = pah.nature_of_action_id and
228: not exists (select 'exists'

Line 266: from ghr_pa_requests

262: -- and person_id = c_person_id
263: -- see comments in the cursor c_history
264: and pa_request_id in
265: (select pa_request_id
266: from ghr_pa_requests
267: start with pa_request_id = c_pa_request_id
268: connect by prior pa_request_id = altered_pa_request_id)
269: and nature_of_action_id = c_noa_id
270: order by pa_history_id;

Line 278: from ghr_pa_requests

274: select min(pa_history_id)
275: from ghr_pa_history
276: where pa_request_id =
277: (select min(pa_request_id)
278: from ghr_pa_requests
279: connect by pa_request_id = prior altered_pa_request_id
280: start with pa_request_id = (select pa_request_id
281: from ghr_pa_history
282: where pa_history_id = cp_pa_history_id))

Line 4499: Procedure cascade_pa_req(p_rfrsh_rec in out nocopy ghr_pa_requests%rowtype,

4495: -- Internal Development Use Only.
4496: --
4497: -- {End Of Comments}
4498: -- ---------------------------------------------------------------------------
4499: Procedure cascade_pa_req(p_rfrsh_rec in out nocopy ghr_pa_requests%rowtype,
4500: p_shadow_rec in out nocopy ghr_pa_requests%rowtype,
4501: p_sf52_rec in out nocopy ghr_pa_requests%rowtype,
4502: p_changed in out nocopy boolean)
4503: is

Line 4500: p_shadow_rec in out nocopy ghr_pa_requests%rowtype,

4496: --
4497: -- {End Of Comments}
4498: -- ---------------------------------------------------------------------------
4499: Procedure cascade_pa_req(p_rfrsh_rec in out nocopy ghr_pa_requests%rowtype,
4500: p_shadow_rec in out nocopy ghr_pa_requests%rowtype,
4501: p_sf52_rec in out nocopy ghr_pa_requests%rowtype,
4502: p_changed in out nocopy boolean)
4503: is
4504:

Line 4501: p_sf52_rec in out nocopy ghr_pa_requests%rowtype,

4497: -- {End Of Comments}
4498: -- ---------------------------------------------------------------------------
4499: Procedure cascade_pa_req(p_rfrsh_rec in out nocopy ghr_pa_requests%rowtype,
4500: p_shadow_rec in out nocopy ghr_pa_requests%rowtype,
4501: p_sf52_rec in out nocopy ghr_pa_requests%rowtype,
4502: p_changed in out nocopy boolean)
4503: is
4504:
4505: l_rfrsh_rec ghr_pa_requests%rowtype;

Line 4505: l_rfrsh_rec ghr_pa_requests%rowtype;

4501: p_sf52_rec in out nocopy ghr_pa_requests%rowtype,
4502: p_changed in out nocopy boolean)
4503: is
4504:
4505: l_rfrsh_rec ghr_pa_requests%rowtype;
4506: l_shadow_rec ghr_pa_Requests%rowtype;
4507: l_sf52_rec ghr_pa_Requests%rowtype;
4508: l_changed_boo Boolean;
4509:

Line 4506: l_shadow_rec ghr_pa_Requests%rowtype;

4502: p_changed in out nocopy boolean)
4503: is
4504:
4505: l_rfrsh_rec ghr_pa_requests%rowtype;
4506: l_shadow_rec ghr_pa_Requests%rowtype;
4507: l_sf52_rec ghr_pa_Requests%rowtype;
4508: l_changed_boo Boolean;
4509:
4510: l_proc varchar2(72) := 'cascade_pa_req';

Line 4507: l_sf52_rec ghr_pa_Requests%rowtype;

4503: is
4504:
4505: l_rfrsh_rec ghr_pa_requests%rowtype;
4506: l_shadow_rec ghr_pa_Requests%rowtype;
4507: l_sf52_rec ghr_pa_Requests%rowtype;
4508: l_changed_boo Boolean;
4509:
4510: l_proc varchar2(72) := 'cascade_pa_req';
4511: l_changed boolean := FALSE;