1484: cursor c_getsessdate is
1485: select trunc(effective_date)
1486: from fnd_sessions
1487: where session_id = (select userenv('sessionid') 1488: from dual); 1489: Begin
1490: open c_getsessdate;
1491: fetch c_getsessdate into p_sess_date;
1492: if c_getsessdate%notfound then