APPS.PO_REQAPPROVAL_FINDAPPRV1 dependencies on PO_EMPLOYEES_CURRENT_X
Line 1855: FROM PO_EMPLOYEES_CURRENT_X HREC, --
1851: Added the LEADING(POEH) hint to get better execution plan */
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