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_EHRI_DYNRPT dependencies on GHR_PA_ROUTING_HISTORY

Line 2387: FROM ghr_pa_routing_history

2383: -- Cursor for getting authorization person details
2384: CURSOR cur_approver_id(c_pa_request_id ghr_pa_requests.pa_request_id%type)
2385: IS
2386: SELECT user_name_employee_id approver_id
2387: FROM ghr_pa_routing_history
2388: WHERE pa_request_id = c_pa_request_id
2389: AND approval_status = 'APPROVE'
2390: AND action_taken IN ('UPDATE_HR','FUTURE_ACTION');
2391:

Line 2392: l_approver_id ghr_pa_routing_history.user_name_employee_id%type;

2388: WHERE pa_request_id = c_pa_request_id
2389: AND approval_status = 'APPROVE'
2390: AND action_taken IN ('UPDATE_HR','FUTURE_ACTION');
2391:
2392: l_approver_id ghr_pa_routing_history.user_name_employee_id%type;
2393: -- End Bug 5010844
2394:
2395: -- Bug#5209089 Created the cursor.
2396: CURSOR cur_poid_approver (c_poid VARCHAR2)