APPS.GHR_PA_REQUESTS_PKG dependencies on GHR_PA_ROUTING_HISTORY

Line 405: ,ghr_pa_routing_history prh

401: ,rli.name
402: ,prh.routing_seq_number
403: ,prh.pa_routing_history_id
404: FROM ghr_routing_lists rli
405: ,ghr_pa_routing_history prh
406: WHERE prh.pa_request_id = p_pa_request_id
407: AND prh.routing_list_id = rli.routing_list_id
408: ORDER BY prh.pa_routing_history_id DESC;
409: -- The order by makes sure the first one we get is the last in the history

Line 415: FROM ghr_pa_routing_history prh

411:
412: -- Just get the last record so we can see if the cursor above got us the last record
413: CURSOR cur_prh_last IS
414: SELECT prh.pa_routing_history_id
415: FROM ghr_pa_routing_history prh
416: WHERE prh.pa_request_id = p_pa_request_id
417: ORDER BY prh.pa_routing_history_id DESC;
418: -- Again the order by saves us having to do a max
419:

Line 494: l_groupbox_id ghr_pa_routing_history.groupbox_id%TYPE;

490: l_personnelist_flag varchar2(150);
491: l_approver_flag varchar2(150);
492: l_reviewer_flag varchar2(150);
493:
494: l_groupbox_id ghr_pa_routing_history.groupbox_id%TYPE;
495: l_user_name ghr_pa_routing_history.user_name%TYPE;
496:
497: CURSOR cur_gp_user IS
498: select prh.groupbox_id

Line 495: l_user_name ghr_pa_routing_history.user_name%TYPE;

491: l_approver_flag varchar2(150);
492: l_reviewer_flag varchar2(150);
493:
494: l_groupbox_id ghr_pa_routing_history.groupbox_id%TYPE;
495: l_user_name ghr_pa_routing_history.user_name%TYPE;
496:
497: CURSOR cur_gp_user IS
498: select prh.groupbox_id
499: ,prh.user_name

Line 500: from ghr_pa_routing_history prh

496:
497: CURSOR cur_gp_user IS
498: select prh.groupbox_id
499: ,prh.user_name
500: from ghr_pa_routing_history prh
501: where prh.pa_request_id = p_pa_request_id
502: order by prh.pa_routing_history_id desc;
503:
504: CURSOR cur_first_user IS

Line 506: from ghr_pa_routing_history prh

502: order by prh.pa_routing_history_id desc;
503:
504: CURSOR cur_first_user IS
505: select prh.groupbox_id
506: from ghr_pa_routing_history prh
507: where prh.pa_request_id = p_pa_request_id
508: and prh.user_name = l_user_name
509: and prh.groupbox_id is not NULL
510: and not exists (select 1

Line 511: from ghr_pa_routing_history prh2

507: where prh.pa_request_id = p_pa_request_id
508: and prh.user_name = l_user_name
509: and prh.groupbox_id is not NULL
510: and not exists (select 1
511: from ghr_pa_routing_history prh2
512: where prh2.pa_request_id = p_pa_request_id
513: and prh2.user_name <> l_user_name
514: and prh2.pa_routing_history_id > prh.pa_routing_history_id)
515: order by prh.pa_routing_history_id asc;

Line 2126: FROM ghr_pa_routing_history prh

2122:
2123: /*CURSOR c_par IS
2124: SELECT par.effective_date effective_date
2125: ,par.altered_pa_request_id
2126: FROM ghr_pa_routing_history prh
2127: ,ghr_pa_requests par
2128: WHERE par.person_id = p_person_id
2129: AND par.effective_date >= p_date
2130: AND prh.pa_request_id = par.pa_request_id

Line 2132: FROM ghr_pa_routing_history prh2

2128: WHERE par.person_id = p_person_id
2129: AND par.effective_date >= p_date
2130: AND prh.pa_request_id = par.pa_request_id
2131: AND prh.pa_routing_history_id = (SELECT MAX(prh2.pa_routing_history_id)
2132: FROM ghr_pa_routing_history prh2
2133: WHERE prh2.pa_request_id = par.pa_request_id)
2134: AND prh.action_taken IN ('FUTURE_ACTION','UPDATE_HR_COMPLETE')
2135: AND par.NOA_FAMILY_CODE != 'CANCEL'
2136: AND ( ( par.second_noa_code IS NULL