APPS.PO_REQAPPROVAL_FINDAPPRV1 dependencies on PO_WORKFORCE_CURRENT_X

Line 1399: FROM FND_USER FND, PO_WORKFORCE_CURRENT_X HR --

1395: */
1396:
1397: cursor C2(username varchar2) is
1398: SELECT HR.PERSON_ID
1399: FROM FND_USER FND, PO_WORKFORCE_CURRENT_X HR --
1400: WHERE FND.USER_NAME = username
1401: AND FND.EMPLOYEE_ID = HR.PERSON_ID
1402: AND ROWNUM = 1;
1403:

Line 1863: FROM PO_WORKFORCE_CURRENT_X cwk, --

1859: AND HREC.employee_id = POEH.superior_id
1860: AND POEH.superior_level > 0
1861: UNION ALL
1862: SELECT /*+ LEADING(POEH) */ poeh.superior_id, poeh.superior_level, cwk.full_name
1863: FROM PO_WORKFORCE_CURRENT_X cwk, --
1864: po_employee_hierarchies poeh
1865: WHERE poeh.position_structure_id = p_approval_path_id
1866: AND poeh.employee_id = p_empid
1867: AND cwk.person_id = poeh.superior_id