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 2541: FROM ghr_pa_routing_history

2537: -- Cursor for getting authorization person details
2538: CURSOR cur_approver_id(c_pa_request_id ghr_pa_requests.pa_request_id%type)
2539: IS
2540: SELECT user_name_employee_id approver_id
2541: FROM ghr_pa_routing_history
2542: WHERE pa_request_id = c_pa_request_id
2543: AND approval_status = 'APPROVE'
2544: AND action_taken IN ('UPDATE_HR','FUTURE_ACTION');
2545:

Line 2546: l_approver_id ghr_pa_routing_history.user_name_employee_id%type;

2542: WHERE pa_request_id = c_pa_request_id
2543: AND approval_status = 'APPROVE'
2544: AND action_taken IN ('UPDATE_HR','FUTURE_ACTION');
2545:
2546: l_approver_id ghr_pa_routing_history.user_name_employee_id%type;
2547: -- End Bug 5010844
2548:
2549: -- Bug#5209089 Created the cursor.
2550: CURSOR cur_poid_approver (c_poid VARCHAR2)