APPS.GHR_PROC_FUT_MT dependencies on GHR_POIS

Line 17: p_poi IN ghr_pois.personnel_office_id%TYPE,

13: -- determine the batch size and call sub programs.
14: -- ============================================================================
15: PROCEDURE EXECUTE_MT( p_errbuf OUT NOCOPY VARCHAR2,
16: p_retcode OUT NOCOPY NUMBER,
17: p_poi IN ghr_pois.personnel_office_id%TYPE,
18: p_batch_size IN NUMBER,
19: p_thread_size IN NUMBER)
20: IS
21: -- Cursor for Future actions when POI parameter is entered

Line 22: CURSOR c_futr_actions_poi(c_poi ghr_pois.personnel_office_id%TYPE) IS

18: p_batch_size IN NUMBER,
19: p_thread_size IN NUMBER)
20: IS
21: -- Cursor for Future actions when POI parameter is entered
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

Line 49: CURSOR c_tot_futr_actions_poi(c_poi ghr_pois.personnel_office_id%TYPE) IS

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
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