DBA Data[Home] [Help]

APPS.PO_APPROVALLIST_S1 dependencies on HR_EMPLOYEES_CURRENT_V

Line 483: FROM hr_employees_current_v hrec,

479: Added the LEADING(POEH) hint to get better execution plan */
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