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_REQAPPROVAL_FINDAPPRV1 dependencies on PO_EMPLOYEE_HIERARCHIES

Line 1856: PO_EMPLOYEE_HIERARCHIES POEH

1852:
1853: Cursor C1(p_empid number, p_approval_path_id number) is
1854: SELECT /*+ LEADING(POEH) */POEH.superior_id, poeh.superior_level, HREC.full_name
1855: FROM PO_EMPLOYEES_CURRENT_X HREC, --
1856: PO_EMPLOYEE_HIERARCHIES POEH
1857: WHERE POEH.position_structure_id = p_approval_path_id
1858: AND POEH.employee_id = p_empid
1859: AND HREC.employee_id = POEH.superior_id
1860: AND POEH.superior_level > 0

Line 1864: po_employee_hierarchies poeh

1860: AND POEH.superior_level > 0
1861: UNION ALL
1862: SELECT /*+ LEADING(POEH) */ poeh.superior_id, poeh.superior_level, cwk.full_name
1863: FROM PO_WORKFORCE_CURRENT_X cwk, --
1864: po_employee_hierarchies poeh
1865: WHERE poeh.position_structure_id = p_approval_path_id
1866: AND poeh.employee_id = p_empid
1867: AND cwk.person_id = poeh.superior_id
1868: AND poeh.superior_level > 0