DBA Data[Home] [Help]

APPS.CS_CHARGE_DETAILS_PVT dependencies on FND_USER

Line 14901: FROM fnd_user

14897: X_RETURN_STATUS OUT NOCOPY VARCHAR2) IS
14898:
14899: CURSOR c_user IS
14900: SELECT 1
14901: FROM fnd_user
14902: WHERE user_id = p_user_id
14903: AND TRUNC(SYSDATE) <= start_date
14904: AND NVL(end_date, SYSDATE) >= SYSDATE;
14905:

Line 14921: FROM fnd_user

14917:
14918: BEGIN
14919: IF p_user_id = -1 then
14920: SELECT 'x' into l_dummy
14921: FROM fnd_user
14922: WHERE user_id = p_user_id;
14923: ELSE
14924: SELECT 'x' into l_dummy
14925: FROM fnd_user

Line 14925: FROM fnd_user

14921: FROM fnd_user
14922: WHERE user_id = p_user_id;
14923: ELSE
14924: SELECT 'x' into l_dummy
14925: FROM fnd_user
14926: WHERE user_id = p_user_id
14927: AND trunc(sysdate) BETWEEN trunc(nvl(start_date, sysdate))
14928: AND trunc(nvl(end_date, sysdate));
14929: END IF;