DBA Data[Home] [Help]

APPS.PO_APPROVALLIST_S1 dependencies on PO_EMPLOYEE_HIERARCHIES

Line 501: po_employee_hierarchies poeh

497:
498: CURSOR c_po_hier(p_employee_id NUMBER, p_approval_path_id NUMBER) IS
499: SELECT /*+ LEADING(POEH) */ poeh.superior_id, poeh.superior_level, hrec.full_name
500: FROM hr_employees_current_v hrec,
501: po_employee_hierarchies poeh
502: WHERE poeh.position_structure_id = p_approval_path_id
503: AND poeh.employee_id = p_employee_id
504: AND hrec.employee_id = poeh.superior_id
505: AND poeh.superior_level > 0

Line 509: po_employee_hierarchies poeh

505: AND poeh.superior_level > 0
506: UNION ALL
507: SELECT /*+ LEADING(POEH) */ poeh.superior_id, poeh.superior_level, cwk.full_name
508: FROM per_cont_workers_current_x cwk,
509: po_employee_hierarchies poeh
510: WHERE poeh.position_structure_id = p_approval_path_id
511: AND poeh.employee_id = p_employee_id
512: AND cwk.person_id = poeh.superior_id
513: AND poeh.superior_level > 0