APPS.PO_REQAPPROVAL_FINDAPPRV1 dependencies on PO_WORKFORCE_CURRENT_X

Line 1541: FROM FND_USER FND, PO_WORKFORCE_CURRENT_X HR --

1537: */
1538:
1539: cursor C2(username varchar2) is
1540: SELECT HR.PERSON_ID
1541: FROM FND_USER FND, PO_WORKFORCE_CURRENT_X HR --
1542: WHERE FND.USER_NAME = username
1543: AND FND.EMPLOYEE_ID = HR.PERSON_ID
1544: AND ROWNUM = 1;
1545:

Line 2005: -- Bug 8549707 - Replaced view PO_WORKFORCE_CURRENT_X from the query with the underlying view basetables

2001:
2002: /* Bug 2437175
2003: Added the LEADING(POEH) hint to get better execution plan */
2004:
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, --