4211: AND NVL(end_date, SYSDATE) >= SYSDATE;
4212:
4213: CURSOR c_login IS
4214: SELECT 1
4215: FROM fnd_logins
4216: WHERE login_id = p_login_id
4217: AND user_id = p_user_id;
4218:
4219: l_dummy VARCHAR2(1);
4246:
4247: IF p_login_id is not null then
4248: BEGIN
4249: SELECT 'x' into l_dummy
4250: FROM fnd_logins
4251: WHERE login_id = p_login_id
4252: AND user_id = p_user_id;
4253:
4254: EXCEPTION