eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_REQAPPROVAL_FINDAPPRV1 dependencies on PO_EMPLOYEE_HIERARCHIES

Line 2010: PO_EMPLOYEE_HIERARCHIES POEH

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
2014: AND POEH.superior_level > 0

Line 2018: PO_EMPLOYEE_HIERARCHIES POEH,

2014: AND POEH.superior_level > 0
2015: UNION ALL
2016: SELECT poeh.superior_id, poeh.superior_level, cwk.full_name
2017: FROM PER_ALL_PEOPLE_F CWK,
2018: PO_EMPLOYEE_HIERARCHIES POEH,
2019: PER_ALL_ASSIGNMENTS_F A,
2020: PER_PERIODS_OF_SERVICE PS
2021: WHERE poeh.position_structure_id = p_approval_path_id
2022: AND poeh.employee_id = p_empid

Line 2039: PO_EMPLOYEE_HIERARCHIES POEH,

2035: UNION ALL
2036: SELECT
2037: POEH.SUPERIOR_ID , POEH.SUPERIOR_LEVEL, CWK.FULL_NAME
2038: FROM PER_ALL_PEOPLE_F CWK,
2039: PO_EMPLOYEE_HIERARCHIES POEH,
2040: PER_ALL_ASSIGNMENTS_F A,
2041: PER_PERIODS_OF_PLACEMENT PP
2042: WHERE poeh.position_structure_id = p_approval_path_id
2043: AND poeh.employee_id = p_empid