DBA Data[Home] [Help]

APPS.CSP_RECEIVE_PVT dependencies on FND_USER

Line 143: FROM FND_USER FND, PER_EMPLOYEES_CURRENT_X HR

139: NVL(HR.LOCATION_ID,0)
140: INTO X_emp_id,
141: X_emp_name,
142: X_location_id
143: FROM FND_USER FND, PER_EMPLOYEES_CURRENT_X HR
144: WHERE FND.USER_ID = X_user_id
145: AND FND.EMPLOYEE_ID = HR.EMPLOYEE_ID
146: AND ROWNUM = 1;
147: /* if no rows selected

Line 144: WHERE FND.USER_ID = X_user_id

140: INTO X_emp_id,
141: X_emp_name,
142: X_location_id
143: FROM FND_USER FND, PER_EMPLOYEES_CURRENT_X HR
144: WHERE FND.USER_ID = X_user_id
145: AND FND.EMPLOYEE_ID = HR.EMPLOYEE_ID
146: AND ROWNUM = 1;
147: /* if no rows selected
148: then user is not an employee