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 4466: Procedure cascade_pa_req(p_rfrsh_rec in out nocopy ghr_pa_requests%rowtype,

4462: -- Internal Development Use Only.
4463: --
4464: -- {End Of Comments}
4465: -- ---------------------------------------------------------------------------
4466: Procedure cascade_pa_req(p_rfrsh_rec in out nocopy ghr_pa_requests%rowtype,
4467: p_shadow_rec in out nocopy ghr_pa_requests%rowtype,
4468: p_sf52_rec in out nocopy ghr_pa_requests%rowtype,
4469: p_changed in out nocopy boolean)
4470: is

Line 4467: p_shadow_rec in out nocopy ghr_pa_requests%rowtype,

4463: --
4464: -- {End Of Comments}
4465: -- ---------------------------------------------------------------------------
4466: Procedure cascade_pa_req(p_rfrsh_rec in out nocopy ghr_pa_requests%rowtype,
4467: p_shadow_rec in out nocopy ghr_pa_requests%rowtype,
4468: p_sf52_rec in out nocopy ghr_pa_requests%rowtype,
4469: p_changed in out nocopy boolean)
4470: is
4471:

Line 4468: p_sf52_rec in out nocopy ghr_pa_requests%rowtype,

4464: -- {End Of Comments}
4465: -- ---------------------------------------------------------------------------
4466: Procedure cascade_pa_req(p_rfrsh_rec in out nocopy ghr_pa_requests%rowtype,
4467: p_shadow_rec in out nocopy ghr_pa_requests%rowtype,
4468: p_sf52_rec in out nocopy ghr_pa_requests%rowtype,
4469: p_changed in out nocopy boolean)
4470: is
4471:
4472: l_rfrsh_rec ghr_pa_requests%rowtype;

Line 4472: l_rfrsh_rec ghr_pa_requests%rowtype;

4468: p_sf52_rec in out nocopy ghr_pa_requests%rowtype,
4469: p_changed in out nocopy boolean)
4470: is
4471:
4472: l_rfrsh_rec ghr_pa_requests%rowtype;
4473: l_shadow_rec ghr_pa_Requests%rowtype;
4474: l_sf52_rec ghr_pa_Requests%rowtype;
4475: l_changed_boo Boolean;
4476:

Line 4473: l_shadow_rec ghr_pa_Requests%rowtype;

4469: p_changed in out nocopy boolean)
4470: is
4471:
4472: l_rfrsh_rec ghr_pa_requests%rowtype;
4473: l_shadow_rec ghr_pa_Requests%rowtype;
4474: l_sf52_rec ghr_pa_Requests%rowtype;
4475: l_changed_boo Boolean;
4476:
4477: l_proc varchar2(72) := 'cascade_pa_req';

Line 4474: l_sf52_rec ghr_pa_Requests%rowtype;

4470: is
4471:
4472: l_rfrsh_rec ghr_pa_requests%rowtype;
4473: l_shadow_rec ghr_pa_Requests%rowtype;
4474: l_sf52_rec ghr_pa_Requests%rowtype;
4475: l_changed_boo Boolean;
4476:
4477: l_proc varchar2(72) := 'cascade_pa_req';
4478: l_changed boolean := FALSE;