APPS.GHR_SESSION SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 24

    select userenv('sessionid') sessionid
    from   dual;

Line: 28

    select effective_date,
           session_id
    from   fnd_sessions
    where  session_id = l_session_id;

Line: 48

      update fnd_sessions
      set    effective_date = p_effective_date
      where  session_id     = l_session_id;

Line: 53

     Insert into fnd_sessions
     (session_id,effective_date)
     values
     (l_session_id,p_effective_date);

Line: 75

    select userenv('sessionid') sessionid
    from   dual;

Line: 79

    select effective_date,
           session_id
    from   fnd_sessions
    where  session_id = l_session_id;

Line: 99

      update fnd_sessions
      set    effective_date = p_effective_date
      where  session_id     = l_session_id;

Line: 104

     Insert into fnd_sessions
     (session_id,effective_date)
     values
     (l_session_id,p_effective_date);