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 113: FROM FND_USER FND, PER_EMPLOYEES_CURRENT_X HR

109: NVL(HR.LOCATION_ID,0)
110: INTO X_emp_id,
111: X_emp_name,
112: X_location_id
113: FROM FND_USER FND, PER_EMPLOYEES_CURRENT_X HR
114: WHERE FND.USER_ID = TO_NUMBER(X_user_id)
115: AND FND.EMPLOYEE_ID = HR.EMPLOYEE_ID
116: AND ROWNUM = 1;
117: /* DEBUG:

Line 374: /* bug 1845314 replaced hr_employees with per_employees_current_x

370: IF x_emp_id IS NOT NULL THEN
371:
372: x_progress := '010';
373:
374: /* bug 1845314 replaced hr_employees with per_employees_current_x
375: for global supervisor support */
376: SELECT full_name
377: INTO x_emp_name
378: FROM po_workforce_current_x --