APPS.GHR_MRE_PKG dependencies on GHR_PA_ROUTING_HISTORY

Line 2711: from ghr_pa_requests pr, ghr_pa_routing_history prh

2707:
2708:
2709: cursor csr_action_taken is
2710: SELECT pr.pa_request_id, max(pa_routing_history_id) pa_routing_history_id
2711: from ghr_pa_requests pr, ghr_pa_routing_history prh
2712: WHERE pr.pa_request_id = prh.pa_request_id
2713: and person_id = p_person_id
2714: and first_noa_code = p_first_noa_code
2715: and effective_DATE = p_effective_DATE

Line 2730: from ghr_pa_routing_history

2726: WHERE pr.pa_request_id = l_pa_request_id;
2727:
2728: cursor pa_hist_cur (p_r_hist_id NUMBER) is
2729: SELECT nvl(action_taken,' ') action_taken
2730: from ghr_pa_routing_history
2731: WHERE pa_routing_history_id = p_r_hist_id;
2732:
2733: l_action_taken ghr_pa_routing_history.action_taken%TYPE;
2734:

Line 2733: l_action_taken ghr_pa_routing_history.action_taken%TYPE;

2729: SELECT nvl(action_taken,' ') action_taken
2730: from ghr_pa_routing_history
2731: WHERE pa_routing_history_id = p_r_hist_id;
2732:
2733: l_action_taken ghr_pa_routing_history.action_taken%TYPE;
2734:
2735:
2736: BEGIN
2737: g_proc := 'person_in_pa_req_1noa';

Line 2794: from ghr_pa_requests pr, ghr_pa_routing_history prh

2790: return BOOLEAN is
2791: --
2792: cursor csr_action_taken is
2793: SELECT pr.pa_request_id, max(pa_routing_history_id) pa_routing_history_id
2794: from ghr_pa_requests pr, ghr_pa_routing_history prh
2795: WHERE pr.pa_request_id = prh.pa_request_id
2796: and nvl(person_id,0) = p_person_id
2797: and nvl(second_noa_code,0) = p_second_noa_code
2798: and trunc(nvl(effective_DATE,sysDATE)) = trunc(p_effective_DATE)

Line 2806: from ghr_pa_routing_history

2802: group by pr.pa_request_id;
2803:
2804: cursor pa_hist_cur (p_r_hist_id NUMBER) is
2805: SELECT nvl(action_taken,' ') action_taken
2806: from ghr_pa_routing_history
2807: WHERE pa_routing_history_id = p_r_hist_id;
2808:
2809: l_action_taken ghr_pa_routing_history.action_taken%TYPE;
2810: BEGIN

Line 2809: l_action_taken ghr_pa_routing_history.action_taken%TYPE;

2805: SELECT nvl(action_taken,' ') action_taken
2806: from ghr_pa_routing_history
2807: WHERE pa_routing_history_id = p_r_hist_id;
2808:
2809: l_action_taken ghr_pa_routing_history.action_taken%TYPE;
2810: BEGIN
2811: g_proc := 'person_in_pa_req_2noa';
2812: for v_action_taken in csr_action_taken
2813: loop