APPS.PO_EMPLOYEES_SV dependencies on PER_EMPLOYEES_CURRENT_X

Line 9: g_emp_name PER_EMPLOYEES_CURRENT_X.FULL_NAME%TYPE;

5: g_asn_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('PO_RVCTP_ENABLE_TRACE'),'N');
6:
7: -- Bug 4664653 START
8: g_emp_id NUMBER;
9: g_emp_name PER_EMPLOYEES_CURRENT_X.FULL_NAME%TYPE;
10: g_location_id NUMBER;
11: g_location_code HR_LOCATIONS.LOCATION_CODE%TYPE;
12: g_is_buyer BOOLEAN;
13: g_emp_flag BOOLEAN;

Line 150: FROM FND_USER FND, PER_EMPLOYEES_CURRENT_X HR

146: NVL(HR.LOCATION_ID,0)
147: INTO X_emp_id,
148: X_emp_name,
149: X_location_id
150: FROM FND_USER FND, PER_EMPLOYEES_CURRENT_X HR
151: WHERE FND.USER_ID = TO_NUMBER(X_user_id)
152: AND FND.EMPLOYEE_ID = HR.EMPLOYEE_ID
153: AND ROWNUM = 1;
154:

Line 485: /* bug 1845314 replaced hr_employees with per_employees_current_x

481: IF x_emp_id IS NOT NULL THEN
482:
483: x_progress := '010';
484:
485: /* bug 1845314 replaced hr_employees with per_employees_current_x
486: for global supervisor support */
487: SELECT full_name
488: INTO x_emp_name
489: FROM po_workforce_current_x --