DBA Data[Home] [Help]

APPS.JTF_IH_CORE_UTIL_PVT dependencies on FND_USER

Line 461: FROM fnd_user

457: BEGIN
458: -- Special check to not check the dates when the user ID is (-1).
459: IF p_user_id = -1 THEN
460: SELECT 'x' INTO l_dummy
461: FROM fnd_user
462: WHERE user_id = p_user_id;
463: ELSE
464: SELECT 'x' INTO l_dummy
465: FROM fnd_user

Line 465: FROM fnd_user

461: FROM fnd_user
462: WHERE user_id = p_user_id;
463: ELSE
464: SELECT 'x' INTO l_dummy
465: FROM fnd_user
466: WHERE user_id = p_user_id
467: AND Trunc(Sysdate) BETWEEN Trunc(Nvl(start_date, Sysdate))
468: AND Trunc(Nvl(end_date, Sysdate));
469: END IF;