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:
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
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;