APPS.GHR_MRE_PKG dependencies on GHR_PA_ROUTING_HISTORY

Line 2557: from ghr_pa_requests pr, ghr_pa_routing_history prh

2553: l_pa_request_id ghr_pa_requests.pa_request_id%TYPE;
2554:
2555: cursor csr_action_taken is
2556: SELECT pr.pa_request_id, max(pa_routing_history_id) pa_routing_history_id
2557: from ghr_pa_requests pr, ghr_pa_routing_history prh
2558: WHERE pr.pa_request_id = prh.pa_request_id
2559: and person_id = p_person_id
2560: and first_noa_code = p_first_noa_code
2561: and effective_DATE = p_effective_DATE

Line 2576: from ghr_pa_routing_history

2572: WHERE pr.pa_request_id = l_pa_request_id;
2573:
2574: cursor pa_hist_cur (p_r_hist_id NUMBER) is
2575: SELECT nvl(action_taken,' ') action_taken
2576: from ghr_pa_routing_history
2577: WHERE pa_routing_history_id = p_r_hist_id;
2578:
2579: l_action_taken ghr_pa_routing_history.action_taken%TYPE;
2580:

Line 2579: l_action_taken ghr_pa_routing_history.action_taken%TYPE;

2575: SELECT nvl(action_taken,' ') action_taken
2576: from ghr_pa_routing_history
2577: WHERE pa_routing_history_id = p_r_hist_id;
2578:
2579: l_action_taken ghr_pa_routing_history.action_taken%TYPE;
2580:
2581: BEGIN
2582: g_proc := 'person_in_pa_req_1noa';
2583:

Line 2633: from ghr_pa_requests pr, ghr_pa_routing_history prh

2629: return BOOLEAN is
2630: --
2631: cursor csr_action_taken is
2632: SELECT pr.pa_request_id, max(pa_routing_history_id) pa_routing_history_id
2633: from ghr_pa_requests pr, ghr_pa_routing_history prh
2634: WHERE pr.pa_request_id = prh.pa_request_id
2635: and nvl(person_id,0) = p_person_id
2636: and nvl(second_noa_code,0) = p_second_noa_code
2637: and trunc(nvl(effective_DATE,sysDATE)) = trunc(p_effective_DATE)

Line 2645: from ghr_pa_routing_history

2641: group by pr.pa_request_id;
2642:
2643: cursor pa_hist_cur (p_r_hist_id NUMBER) is
2644: SELECT nvl(action_taken,' ') action_taken
2645: from ghr_pa_routing_history
2646: WHERE pa_routing_history_id = p_r_hist_id;
2647:
2648: l_action_taken ghr_pa_routing_history.action_taken%TYPE;
2649: BEGIN

Line 2648: l_action_taken ghr_pa_routing_history.action_taken%TYPE;

2644: SELECT nvl(action_taken,' ') action_taken
2645: from ghr_pa_routing_history
2646: WHERE pa_routing_history_id = p_r_hist_id;
2647:
2648: l_action_taken ghr_pa_routing_history.action_taken%TYPE;
2649: BEGIN
2650: g_proc := 'person_in_pa_req_2noa';
2651: for v_action_taken in csr_action_taken
2652: loop