DBA Data[Home] [Help]

APPS.HXT_TIM_COL_UTIL dependencies on FND_SESSIONS

Line 508: Get the current session date from fnd_sessions.

504:
505:
506: /*******************************************************************
507: get_session_date()
508: Get the current session date from fnd_sessions.
509: ********************************************************************/
510: FUNCTION get_session_date(o_sess_date OUT NOCOPY DATE )RETURN NUMBER
511: IS
512: hold_sess_date DATE;

Line 516: FROM fnd_sessions

512: hold_sess_date DATE;
513: BEGIN
514: SELECT effective_date
515: INTO hold_sess_date
516: FROM fnd_sessions
517: WHERE session_id = USERENV('SESSIONID');
518: --
519: o_sess_date := hold_sess_date;
520: --