DBA Data[Home] [Help]

APPS.CS_COST_DETAILS_PVT dependencies on FND_USER

Line 4208: FROM fnd_user

4204: X_RETURN_STATUS OUT NOCOPY VARCHAR2) IS
4205:
4206: CURSOR c_user IS
4207: SELECT 1
4208: FROM fnd_user
4209: WHERE user_id = p_user_id
4210: AND TRUNC(SYSDATE) <= start_date
4211: AND NVL(end_date, SYSDATE) >= SYSDATE;
4212:

Line 4228: FROM fnd_user

4224:
4225: BEGIN
4226: IF p_user_id = -1 then
4227: SELECT 'x' into l_dummy
4228: FROM fnd_user
4229: WHERE user_id = p_user_id;
4230: ELSE
4231: SELECT 'x' into l_dummy
4232: FROM fnd_user

Line 4232: FROM fnd_user

4228: FROM fnd_user
4229: WHERE user_id = p_user_id;
4230: ELSE
4231: SELECT 'x' into l_dummy
4232: FROM fnd_user
4233: WHERE user_id = p_user_id
4234: AND trunc(sysdate) BETWEEN trunc(nvl(start_date, sysdate))
4235: AND trunc(nvl(end_date, sysdate));
4236: END IF;