APPS.WSH_UTIL_VALIDATE dependencies on FND_USER

Line 1277: -- COMMENT : Validates User_id and User_name against table fnd_user

1273:
1274: --========================================================================
1275: -- PROCEDURE : Validate_User
1276: --
1277: -- COMMENT : Validates User_id and User_name against table fnd_user
1278: -- If both values are specified then only User_id is used
1279: --========================================================================
1280:
1281: PROCEDURE Validate_User

Line 1288: FROM fnd_user

1284: x_return_status OUT NOCOPY VARCHAR2) IS
1285:
1286: CURSOR check_user IS
1287: SELECT user_id
1288: FROM fnd_user
1289: WHERE p_user_id IS NOT NULL AND
1290: user_id = p_user_id AND
1291: trunc(sysdate) between nvl( start_date, trunc(sysdate) )
1292: and nvl( end_date, trunc(sysdate) )

Line 1295: FROM fnd_user

1291: trunc(sysdate) between nvl( start_date, trunc(sysdate) )
1292: and nvl( end_date, trunc(sysdate) )
1293: UNION ALL
1294: SELECT user_id
1295: FROM fnd_user
1296: WHERE p_user_id IS NULL AND
1297: user_name = p_user_name AND
1298: trunc(sysdate) between nvl( start_date, trunc(sysdate) )
1299: and nvl( end_date, trunc(sysdate) );