eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GHR_PROC_FUT_MT dependencies on GHR_NATURE_OF_ACTIONS

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