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.PO_APPROVALLIST_S1 dependencies on PO_EMPLOYEE_HIERARCHIES

Line 484: po_employee_hierarchies poeh

480:
481: CURSOR c_po_hier(p_employee_id NUMBER, p_approval_path_id NUMBER) IS
482: SELECT /*+ LEADING(POEH) */ poeh.superior_id, poeh.superior_level, hrec.full_name
483: FROM hr_employees_current_v hrec,
484: po_employee_hierarchies poeh
485: WHERE poeh.position_structure_id = p_approval_path_id
486: AND poeh.employee_id = p_employee_id
487: AND hrec.employee_id = poeh.superior_id
488: AND poeh.superior_level > 0

Line 492: po_employee_hierarchies poeh

488: AND poeh.superior_level > 0
489: UNION ALL
490: SELECT /*+ LEADING(POEH) */ poeh.superior_id, poeh.superior_level, cwk.full_name
491: FROM per_cont_workers_current_x cwk,
492: po_employee_hierarchies poeh
493: WHERE poeh.position_structure_id = p_approval_path_id
494: AND poeh.employee_id = p_employee_id
495: AND cwk.person_id = poeh.superior_id
496: AND poeh.superior_level > 0