APPS.IGI_GEN SQL Statements

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

Line: 16

         SELECT status_flag
         FROM   igi_gcc_inst_options_all -- Use _ALL table instead of view
         WHERE  option_name = upper(p_option_name)
         AND    org_id             = p_org_id;

Line: 24

         SELECT status_flag
         FROM   igi_gcc_gl_fa_inst_ops
         WHERE  option_name = upper(p_option_name) ;

Line: 59

         SELECT status_flag
         FROM   igi_gcc_installed_options
         WHERE  option_name = upper(p_option_name);

Line: 66

         SELECT status_flag
         FROM   IGI_gcc_gl_fa_inst_ops
         WHERE  option_name = upper(p_option_name) ;

Line: 124

            insert into IGI_debug_all ( MODULE
                                    , MODULE_VARIABLE
                                    , VARIABLE_VALUE
                                    , MODULE_MESSAGE
                                    , DEBUG_SEQUENCE)
            select                    p_module
                                    , p_module_variable
                                    , p_variable_value
                                    , P_message
                                    , IGI_debug_s.nextval
            from dual;

Line: 156

         (SELECT status_flag
         FROM   IGI_gcc_installed_options
         WHERE  option_name = upper(p_option_name ));

Line: 162

          (SELECT status_flag
          FROM   IGI_gcc_gl_fa_inst_ops
          WHERE  option_name = upper(p_option_name ))  ;

Line: 198

   SELECT meaning into l_return_meaning
          from IGI_LOOKUPS
          WHERE LOOKUP_TYPE = l_lookup_type;

Line: 218

  SELECT  mult_funding_budgets_flag
  FROM  psa_efc_options
  WHERE set_of_books_id = p_sob;

Line: 256

        SELECT set_of_books_id
        INTO   p_sob_id
        FROM   ap_system_parameters;

Line: 270

        SELECT set_of_books_id
        INTO   p_sob_id
        FROM   ar_system_parameters;

Line: 284

        SELECT set_of_books_id
        INTO   p_sob_id
        FROM   financials_system_parameters;

Line: 298

      Select meaning
      from igi_lookups
      Where lookup_type = 'IGI_PROMPTS'
        and lookup_code = p_lookup_code;