APPS.PO_EMPLOYEES_SV dependencies on FND_USER

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 114: WHERE FND.USER_ID = TO_NUMBER(X_user_id)

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:
118: ** GK:This column has been obsoleted by AOL. Need to check

Line 137: FROM FND_USER FND, PER_WORKFORCE_CURRENT_X HR

133: NVL(HR.LOCATION_ID,0)
134: INTO X_emp_id,
135: X_emp_name,
136: X_location_id
137: FROM FND_USER FND, PER_WORKFORCE_CURRENT_X HR
138: WHERE FND.USER_ID = TO_NUMBER(X_user_id)
139: AND FND.EMPLOYEE_ID = HR.PERSON_ID
140: AND ROWNUM = 1;
141:

Line 138: WHERE FND.USER_ID = TO_NUMBER(X_user_id)

134: INTO X_emp_id,
135: X_emp_name,
136: X_location_id
137: FROM FND_USER FND, PER_WORKFORCE_CURRENT_X HR
138: WHERE FND.USER_ID = TO_NUMBER(X_user_id)
139: AND FND.EMPLOYEE_ID = HR.PERSON_ID
140: AND ROWNUM = 1;
141:
142: END IF;

Line 312: FROM fnd_user

308: x_progress := '010';
309:
310: SELECT count(*)
311: INTO x_data_exists
312: FROM fnd_user
313: WHERE employee_id = x_person_id
314: AND sysdate < nvl(end_date, sysdate + 1);
315: /* DEBUG:
316: ** GK:This column has been obsoleted by AOL. Need to check