APPS.GHR_PROC_FUT_MT dependencies on GHR_PA_ROUTING_HISTORY

Line 26: FROM ghr_pa_requests a, ghr_pa_routing_history b,ghr_nature_of_actions noa

22: CURSOR c_futr_actions_poi(c_poi ghr_pois.personnel_office_id%TYPE) IS
23: SELECT a.person_id,a.effective_date,noa.order_of_processing,
24: a.pa_request_id,a.first_noa_code,a.object_version_number,
25: a.employee_last_name, a.employee_first_name,a.employee_national_identifier
26: FROM ghr_pa_requests a, ghr_pa_routing_history b,ghr_nature_of_actions noa
27: WHERE effective_date <= sysdate
28: AND pa_notification_id IS NULL
29: AND approval_date IS NOT NULL
30: AND a.pa_request_id = b.pa_request_id

Line 44: FROM ghr_pa_routing_history

40: WHERE per.person_id = a.person_id
41: AND a.effective_date BETWEEN
42: per.effective_start_date AND per.effective_end_date )
43: AND b.pa_routing_history_id = (SELECT max(pa_routing_history_id)
44: FROM ghr_pa_routing_history
45: WHERE pa_request_id = a.pa_request_id)
46: ORDER BY person_id,effective_date,order_of_processing;
47:
48: -- Cursor to find total future action records if POI parameter is entered

Line 51: FROM ghr_pa_requests a, ghr_pa_routing_history b,ghr_nature_of_actions noa

47:
48: -- Cursor to find total future action records if POI parameter is entered
49: CURSOR c_tot_futr_actions_poi(c_poi ghr_pois.personnel_office_id%TYPE) IS
50: SELECT COUNT(*) fut_cnt
51: FROM ghr_pa_requests a, ghr_pa_routing_history b,ghr_nature_of_actions noa
52: WHERE effective_date <= sysdate
53: AND pa_notification_id IS NULL
54: AND approval_date IS NOT NULL
55: AND a.pa_request_id = b.pa_request_id

Line 69: FROM ghr_pa_routing_history

65: WHERE per.person_id = a.person_id
66: AND a.effective_date BETWEEN
67: per.effective_start_date AND per.effective_end_date )
68: AND b.pa_routing_history_id = (SELECT max(pa_routing_history_id)
69: FROM ghr_pa_routing_history
70: WHERE pa_request_id = a.pa_request_id);
71:
72:
73: -- Cursor to fetch future action records when POI parameter is not entered.

Line 79: FROM ghr_pa_requests a, ghr_pa_routing_history b,ghr_nature_of_actions noa

75: CURSOR c_futr_actions IS
76: SELECT a.person_id,a.effective_date,noa.order_of_processing,
77: a.pa_request_id,a.first_noa_code,a.object_version_number,
78: a.employee_last_name, a.employee_first_name,a.employee_national_identifier
79: FROM ghr_pa_requests a, ghr_pa_routing_history b,ghr_nature_of_actions noa
80: WHERE effective_date <= sysdate
81: AND pa_notification_id IS NULL
82: AND approval_date IS NOT NULL
83: AND a.pa_request_id = b.pa_request_id

Line 93: FROM ghr_pa_routing_history

89: WHERE per.person_id = a.person_id
90: AND a.effective_date BETWEEN
91: per.effective_start_date AND per.effective_end_date )
92: AND b.pa_routing_history_id = (SELECT max(pa_routing_history_id)
93: FROM ghr_pa_routing_history
94: WHERE pa_request_id = a.pa_request_id)
95: ORDER BY person_id,effective_date,order_of_processing;
96:
97: -- Cursor to find total future action records when POI parameter is not entered.

Line 100: FROM ghr_pa_requests a, ghr_pa_routing_history b,ghr_nature_of_actions noa

96:
97: -- Cursor to find total future action records when POI parameter is not entered.
98: CURSOR c_tot_futr_actions IS
99: SELECT COUNT(*) fut_cnt
100: FROM ghr_pa_requests a, ghr_pa_routing_history b,ghr_nature_of_actions noa
101: WHERE effective_date <= sysdate
102: AND pa_notification_id IS NULL
103: AND approval_date IS NOT NULL
104: AND a.pa_request_id = b.pa_request_id

Line 114: FROM ghr_pa_routing_history

110: WHERE per.person_id = a.person_id
111: AND a.effective_date BETWEEN
112: per.effective_start_date AND per.effective_end_date )
113: AND b.pa_routing_history_id = (SELECT max(pa_routing_history_id)
114: FROM ghr_pa_routing_history
115: WHERE pa_request_id = a.pa_request_id);
116:
117: CURSOR c_completion_status(c_session_id NUMBER) IS
118: SELECT max(completion_status) max_status

Line 964: FROM ghr_pa_requests a, ghr_pa_routing_history b

960: l_ovn NUMBER;
961:
962: CURSOR c_pending_action_exists(c_person_id NUMBER, c_effective_date Date) IS
963: SELECT 'X'
964: FROM ghr_pa_requests a, ghr_pa_routing_history b
965: WHERE a.effective_date between (c_effective_date - 2) and (c_effective_date + 1)
966: AND a.person_id = c_person_id
967: AND (substr(a.first_noa_code,1,1) = '5' OR a.first_noa_code IN ('760','762','765'))
968: AND pa_notification_id IS NULL

Line 979: FROM ghr_pa_routing_history

975: WHERE per.person_id = a.person_id
976: AND a.effective_date BETWEEN
977: per.effective_start_date AND per.effective_end_date )
978: AND b.pa_routing_history_id = (SELECT max(pa_routing_history_id)
979: FROM ghr_pa_routing_history
980: WHERE pa_request_id = a.pa_request_id);
981: CURSOR c_processed_action_exists(c_person_id NUMBER, c_effective_date DATE) IS
982: SELECT 'Y'
983: FROM ghr_pa_requests