APPS.IGI_GEN_VERT SQL Statements

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

Line: 12

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

Line: 19

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

Line: 55

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

Line: 61

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

Line: 112

            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: 144

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

Line: 150

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

Line: 186

   SELECT meaning into l_return_meaning
          from IGI_LOOKUPS
          WHERE LOOKUP_TYPE = l_lookup_type;

Line: 206

	SELECT	mult_funding_budgets_flag
	FROM	psa_efc_options
	WHERE	set_of_books_id = p_sob;

Line: 244

        SELECT set_of_books_id
        INTO   p_sob_id
        FROM   ap_system_parameters;

Line: 258

        SELECT set_of_books_id
        INTO   p_sob_id
        FROM   ar_system_parameters;

Line: 272

        SELECT set_of_books_id
        INTO   p_sob_id
        FROM   financials_system_parameters;

Line: 297

       SELECT 'x'
       FROM   igi_gcc_gl_fa_inst_ops
       WHERE  status_flag = 'Y';

Line: 332

 (SELECT option_name
 FROM   IGI_gcc_installed_options
 WHERE  status_flag = 'Y')
UNION
 (SELECT option_name
 FROM   IGI_gcc_gl_fa_inst_ops
 WHERE  status_flag = 'Y');

Line: 471

 (SELECT option_name
 FROM   IGI_gcc_installed_options
 WHERE  status_flag = 'Y')
UNION
 (SELECT option_name
 FROM   IGI_gcc_gl_fa_inst_ops
 WHERE  status_flag = 'Y');