DBA Data[Home] [Help]

APPS.CS_SERVICEREQUEST_UTIL dependencies on FND_USER

Line 904: FROM fnd_user

900:
901: -- Special check to not check the dates when the user ID is (-1).
902: IF p_user_id = -1 THEN
903: SELECT 'x' INTO l_dummy
904: FROM fnd_user
905: WHERE user_id = p_user_id;
906: ELSE
907: SELECT 'x' INTO l_dummy
908: FROM fnd_user

Line 908: FROM fnd_user

904: FROM fnd_user
905: WHERE user_id = p_user_id;
906: ELSE
907: SELECT 'x' INTO l_dummy
908: FROM fnd_user
909: WHERE user_id = p_user_id
910: AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(start_date, SYSDATE))
911: AND TRUNC(NVL(end_date, SYSDATE));
912: END IF;