DBA Data[Home] [Help]

APPS.CS_COST_DETAILS_PVT dependencies on FND_USER

Line 4311: FROM fnd_user

4307: X_RETURN_STATUS OUT NOCOPY VARCHAR2) IS
4308:
4309: CURSOR c_user IS
4310: SELECT 1
4311: FROM fnd_user
4312: WHERE user_id = p_user_id
4313: AND TRUNC(SYSDATE) <= start_date
4314: AND NVL(end_date, SYSDATE) >= SYSDATE;
4315:

Line 4331: FROM fnd_user

4327:
4328: BEGIN
4329: IF p_user_id = -1 then
4330: SELECT 'x' into l_dummy
4331: FROM fnd_user
4332: WHERE user_id = p_user_id;
4333: ELSE
4334: SELECT 'x' into l_dummy
4335: FROM fnd_user

Line 4335: FROM fnd_user

4331: FROM fnd_user
4332: WHERE user_id = p_user_id;
4333: ELSE
4334: SELECT 'x' into l_dummy
4335: FROM fnd_user
4336: WHERE user_id = p_user_id
4337: AND trunc(sysdate) BETWEEN trunc(nvl(start_date, sysdate))
4338: AND trunc(nvl(end_date, sysdate));
4339: END IF;