DBA Data[Home] [Help]

APPS.PO_REQAPPROVAL_FINDAPPRV1 dependencies on PO_EMPLOYEES_CURRENT_X

Line 2009: FROM PO_EMPLOYEES_CURRENT_X HREC, --

2005: -- Bug 8549707 - Replaced view PO_WORKFORCE_CURRENT_X from the query with the underlying view basetables
2006:
2007: Cursor C1(p_empid number, p_approval_path_id number) is
2008: SELECT POEH.superior_id, poeh.superior_level, HREC.full_name
2009: FROM PO_EMPLOYEES_CURRENT_X HREC, --
2010: PO_EMPLOYEE_HIERARCHIES POEH
2011: WHERE POEH.position_structure_id = p_approval_path_id
2012: AND POEH.employee_id = p_empid
2013: AND HREC.employee_id = POEH.superior_id