APPS.CS_CHARGE_DETAILS_PVT dependencies on FND_USER

Line 16472: FROM fnd_user

16468: X_RETURN_STATUS OUT NOCOPY VARCHAR2) IS
16469:
16470: CURSOR c_user IS
16471: SELECT 1
16472: FROM fnd_user
16473: WHERE user_id = p_user_id
16474: AND TRUNC(SYSDATE) <= start_date
16475: AND NVL(end_date, SYSDATE) >= SYSDATE;
16476:

Line 16492: FROM fnd_user

16488:
16489: BEGIN
16490: IF p_user_id = -1 then
16491: SELECT 'x' into l_dummy
16492: FROM fnd_user
16493: WHERE user_id = p_user_id;
16494: ELSE
16495: SELECT 'x' into l_dummy
16496: FROM fnd_user

Line 16496: FROM fnd_user

16492: FROM fnd_user
16493: WHERE user_id = p_user_id;
16494: ELSE
16495: SELECT 'x' into l_dummy
16496: FROM fnd_user
16497: WHERE user_id = p_user_id
16498: AND trunc(sysdate) BETWEEN trunc(nvl(start_date, sysdate))
16499: AND trunc(nvl(end_date, sysdate));
16500: END IF;