1482: Procedure get_session_date ( p_sess_date out nocopy date) is
1483: l_proc varchar2(30);
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;