1491: Procedure get_session_date ( p_sess_date out nocopy date) is
1492: l_proc varchar2(30);
1493: cursor c_getsessdate is
1494: select trunc(effective_date) 1495: from fnd_sessions 1496: where session_id = (select userenv('sessionid')
1497: from dual);
1498: Begin
1499: open c_getsessdate;