DBA Data[Home] [Help]

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