APPS.APP_SESSION SQL Statements

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

Line: 14

  select oracle_username
  into l_apps_sname
  from fnd_oracle_userid
  where oracle_id = 900;

Line: 82

      select application_id
        into l_resp_appl_id
        from fnd_application
       where application_short_name = p_resp_appl_short_name;

Line: 87

      select responsibility_id
        into l_responsibility_id
        from fnd_responsibility
       where application_id = l_resp_appl_id
         and responsibility_key = p_responsibility_key;

Line: 93

      select security_group_id
        into l_security_group_id
        from fnd_security_groups
       where security_group_key = p_security_group_key;

Line: 123

        select fu.user_guid,
               fu.user_id
          into l_user_guid,
               l_user_id
          from icx_sessions ses,
               fnd_user fu
         where ses.user_id = fu.user_id
           and ses.session_id = l_session_id;

Line: 347

    select fu.user_id, fu.user_name, 'N'
    from fnd_user fu
    where fu.user_guid = l_sso_guid
    order by user_id;