APPS.ICX_ADMIN_SIG SQL Statements

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

Line: 46

     select ffunc.function_name
     into   l_application_short_name
     from   fnd_form_functions_vl ffunc,
            icx_sessions icx
     where  icx.session_id = l_session_id
     and    icx.function_id = ffunc.function_id;

Line: 137

    select application_short_name
      into l_application_short_name
      from fnd_application
     where application_id = p_application_id;

Line: 205

     select ffunc.function_name
     into   l_application_short_name
     from   fnd_form_functions_vl ffunc,
            icx_sessions icx
     where  icx.session_id = l_session_id
     and    icx.function_id = ffunc.function_id;

Line: 650

          update icx_sessions
             set    disabled_flag = 'Y'
             where  session_id = l_session_id;

Line: 655

          select HOME_URL, MODE_CODE, Login_id
             into   l_url, l_mode_code, l_login_id
             from   ICX_SESSIONS
             where  SESSION_ID = l_session_id; -- mputman added (l_)login_id for call to fnd_signon.

Line: 671

          select HOME_URL
          into   l_url1
          from   ICX_PARAMETERS;

Line: 692

	    select HOME_URL
	    into   l_url
	    from   ICX_PARAMETERS;