APPS.GCS_CREATE_DYN_INDEX_PKG SQL Statements

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

Line: 10

			SELECT  DECODE(ftcp.column_name, 'INTERCOMPANY_ID', 'INTERCOMPANY_DISPLAY_CODE',
      				                               dtc.column_name) active_columns
			FROM    fem_tab_column_prop ftcp,
            			fem_tab_columns_b   ftcb,
            			fem_xdim_dimensions fxd,
            			dba_tab_columns     dtc
			WHERE   ftcp.table_name             =   'FEM_BALANCES'
			AND     ftcp.column_name            =   ftcb.column_name
			AND     ftcp.column_property_code   =   'PROCESSING_KEY'
			AND     ftcb.table_name             =   ftcp.table_name
			AND     ftcb.dimension_id           =   fxd.dimension_id
			AND     dtc.column_name             =   fxd.member_display_code_col
			AND     dtc.table_name              =   'GCS_BAL_INTERFACE_T'
			AND     dtc.owner                   =   'GCS';

Line: 60

      SELECT epb_column colname
      FROM GCS_EPB_DIM_MAPS
      WHERE enabled_flag = 'Y';

Line: 66

      SELECT owner,
             index_name
      FROM   dba_indexes
      WHERE  table_name  = p_data_table
      AND    owner       = p_index_owner;

Line: 77

      SELECT epb_table_name
      INTO l_data_table
      FROM gcs_system_options;

Line: 81

      SELECT oracle_username
      INTO   l_table_owner
      FROM   fnd_oracle_userid
      WHERE  oracle_id     =    274;

Line: 93

      SELECT  count(*)
      INTO rowcount
      FROM FEM_TAB_COLUMN_PROP
      WHERE table_name = l_data_table
      AND column_property_code = 'PROCESSING_KEY';

Line: 99

      EXECUTE IMMEDIATE 'select count(1) from ' || l_data_table INTO rowcount;

Line: 108

        DELETE FROM fem_tab_column_prop
        WHERE       table_name = l_data_table
        AND         column_property_code = 'PROCESSING_KEY';

Line: 112

        INSERT INTO FEM_TAB_COLUMN_PROP
        ( table_name,
          column_name,
          column_property_code,
          creation_date, created_by,
          last_updated_by,
          last_update_date,
          last_update_login,
          object_version_number)
        (
          SELECT l_data_table,
                 epb_column,
                 'PROCESSING_KEY',
                 sysdate,
                 FND_GLOBAL.user_id,
                 FND_GLOBAL.user_id,
                 sysdate,
                 FND_GLOBAL.login_id,
                 1
          FROM   GCS_EPB_DIM_MAPS
          WHERE  enabled_flag = 'Y'
         );

Line: 226

    body:= ' CREATE UNIQUE INDEX GCS_HISTORICAL_RATES_U1 ON GCS_HISTORICAL_RATES (hierarchy_id, entity_id, from_currency, to_currency, update_flag, ';

Line: 260

    SELECT nvl(fch_global_vs_combo_id, -1)
     INTO  l_sys_option
     FROM gcs_system_options;

Line: 270

    SELECT nvl(epb_table_name, 'INVALID')
      INTO l_epb_table
      FROM gcs_system_options;