APPS.GCS_BUILD_EPB_DIM_TR_PKG SQL Statements

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

Line: 128

     SELECT enabled_flag, 'FEM_' || substr(epb_column,0, 10), epb_column
       INTO l_felm_req, l_felm_tab, l_felm_column
       FROM GCS_EPB_DIM_MAPS
      WHERE gcs_column = 'FINANCIAL_ELEM_ID';

Line: 138

     SELECT fch_global_vs_combo_id
       INTO l_global_vs_id
       FROM gcs_system_options;

Line: 144

       SELECT value_set_display_code, value_set_id
         INTO l_felm_value_set, l_fe_value_setid
         FROM fem_value_sets_b
        WHERE value_set_id = ( SELECT gvs.value_set_id
                                 FROM FEM_GLOBAL_VS_COMBO_DEFS gvs, FEM_TAB_COLUMNS_B dim
                                 WHERE gvs.global_vs_combo_id = l_global_vs_id
                                   AND dim.fem_data_type_code = 'DIMENSION'
                                   AND gvs.dimension_id = dim.dimension_id
                                   AND dim.table_name = 'FEM_BALANCES'
                                   AND dim.column_name = l_felm_column) ;

Line: 180

     SELECT enabled_flag, 'FEM_' || substr(epb_column,0, 10), epb_column
       INTO l_interco_req, l_interco_tab, l_interco_column
       FROM GCS_EPB_DIM_MAPS
      WHERE gcs_column = 'INTERCOMPANY_ID';

Line: 191

       SELECT value_set_display_code, value_set_id
         INTO l_interco_value_set, l_interco_value_setid
         FROM fem_value_sets_b
        WHERE value_set_id = ( SELECT gvs.value_set_id
                                 FROM FEM_GLOBAL_VS_COMBO_DEFS gvs, FEM_TAB_COLUMNS_B dim
                                 WHERE gvs.global_vs_combo_id = l_global_vs_id
                                   AND dim.fem_data_type_code = 'DIMENSION'
                                   AND gvs.dimension_id = dim.dimension_id
                                   AND dim.table_name = 'FEM_BALANCES'
                                   AND dim.column_name = l_interco_column) ;

Line: 226

     SELECT enabled_flag, 'FEM_' || substr(epb_column,0, 10), epb_column
       INTO l_na_req, l_na_tab, l_na_column
       FROM GCS_EPB_DIM_MAPS
      WHERE gcs_column = 'NATURAL_ACCOUNT_ID';

Line: 237

       SELECT value_set_display_code, value_set_id
         INTO l_na_value_set, l_na_value_setid
         FROM fem_value_sets_b
        WHERE value_set_id = ( SELECT gvs.value_set_id
                                 FROM FEM_GLOBAL_VS_COMBO_DEFS gvs, FEM_TAB_COLUMNS_B dim
                                 WHERE gvs.global_vs_combo_id = l_global_vs_id
                                   AND dim.fem_data_type_code = 'DIMENSION'
                                   AND dim.table_name = 'FEM_BALANCES'
                                   AND gvs.dimension_id = dim.dimension_id
                                   AND dim.column_name = l_na_column) ;

Line: 274

     SELECT fch_global_vs_combo_id
       INTO l_global_vs_id
       FROM gcs_system_options;

Line: 279

     SELECT enabled_flag, 'FEM_' || substr(epb_column,0, 10), epb_column
       INTO l_category_req, l_category_tab, l_cat_column
       FROM GCS_EPB_DIM_MAPS
      WHERE gcs_column = 'CREATED_BY_OBJECT_ID';

Line: 290

        SELECT value_set_display_code, value_set_id
         INTO l_cat_value_set, l_cat_value_setid
         FROM fem_value_sets_b
        WHERE value_set_id = ( SELECT gvs.value_set_id
                                 FROM FEM_GLOBAL_VS_COMBO_DEFS gvs, FEM_TAB_COLUMNS_B dim
                                 WHERE gvs.global_vs_combo_id = l_global_vs_id
                                   AND dim.fem_data_type_code = 'DIMENSION'
                                   AND gvs.dimension_id = dim.dimension_id
                                   AND dim.table_name = 'FEM_BALANCES'
                                   AND dim.column_name = l_cat_column) ;

Line: 379

  body:= '       INSERT INTO ' ||  l_felm_btab || ' (' || l_felm_col || ', value_set_display_code, status)';

Line: 381

          SELECT ';

Line: 386

               ( SELECT ' || l_felm_col || '
                  FROM ' || l_felm_b || '
                  WHERE value_set_id = ' || l_fe_value_setid  || ' );' ;

Line: 394

        INSERT INTO ' || l_felm_tltab || ' (' || l_felm_col || ', value_set_display_code, status, language, description, ';

Line: 397

          SELECT financial_elem_display_code, ''' || l_felm_value_set ;

Line: 403

               ( SELECT ' || l_felm_col || '
                  FROM ' || l_felm_b || '
                  WHERE value_set_id = ' || l_fe_value_setid  || ' );' ;

Line: 418

        INSERT INTO ' || l_felm_attrtab || ' (' || l_felm_col ;

Line: 420

        SELECT ';

Line: 426

               ( SELECT ' || l_felm_col || '
                  FROM ' || l_felm_b || '
                  WHERE value_set_id = ' || l_fe_value_setid  || ' );' ;

Line: 433

        INSERT INTO ' || l_felm_attrtab || ' (' || l_felm_col ;

Line: 435

        SELECT ';

Line: 441

               ( SELECT ' || l_felm_col || '
                  FROM ' || l_felm_b || '
                  WHERE value_set_id = ' || l_fe_value_setid  || ' );' ;

Line: 481

  body:= 'INSERT INTO ' ||  l_na_btab || ' (' || l_na_col || ', value_set_display_code, status)
          SELECT ';

Line: 487

               ( SELECT ' || l_na_col || '
                  FROM ' || l_na_b || '
                  WHERE value_set_id = ' || l_na_value_setid  || ' );' ;

Line: 492

          INSERT INTO ' || l_na_tltab || ' (' || l_na_col || ', value_set_display_code, status, language, description, ';

Line: 494

          SELECT natural_account_display_code, ''' || l_na_value_set ;

Line: 499

               ( SELECT ' || l_na_col || '
                  FROM ' || l_na_b || '
                  WHERE value_set_id = ' || l_na_value_setid  || ' );' ;

Line: 514

  body := 'INSERT INTO ' || l_na_attrtab || ' (' || l_na_col ;

Line: 516

           SELECT ';

Line: 522

               ( SELECT ' || l_na_col || '
                  FROM ' || l_na_b || '
                  WHERE value_set_id = ' || l_na_value_setid  || ' );' ;

Line: 529

    INSERT INTO ' || l_na_attrtab || ' (' || l_na_col ;

Line: 531

    SELECT ';

Line: 537

               ( SELECT ' || l_na_col || '
                  FROM ' || l_na_b || '
                  WHERE value_set_id = ' || l_na_value_setid  || ' );' ;

Line: 579

  body:= 'INSERT INTO ' ||  l_category_btab || ' (' || l_category_col || ', value_set_display_code, status)
          SELECT ';

Line: 584

               ( SELECT ' || l_category_col || '
                  FROM ' || l_category_b || '
                  WHERE value_set_id = ' || l_cat_value_setid  || ' );' ;

Line: 589

          INSERT INTO ' || l_category_tltab || ' (' || l_category_col || ', value_set_display_code, status, language, description, ';

Line: 591

          SELECT category_code, ''' || l_cat_value_set ;

Line: 596

                ( SELECT ' || l_category_col || '
                  FROM ' || l_category_b || '
                  WHERE value_set_id = ' || l_cat_value_setid  || ' );' ;

Line: 610

  body := body || 'INSERT INTO ' || l_cat_attrtab || ' (' || l_category_col ;

Line: 612

                   SELECT ';

Line: 617

                      ( SELECT ' || l_category_col || '
                        FROM ' || l_category_b || '
                        WHERE value_set_id = ' || l_cat_value_setid  || ' );' ;

Line: 622

    INSERT INTO ' || l_cat_attrtab || ' (' || l_category_col ;

Line: 624

    SELECT ';

Line: 629

                      ( SELECT ' || l_category_col || '
                        FROM ' || l_category_b || '
                        WHERE value_set_id = ' || l_cat_value_setid  || ' );' ;

Line: 674

  body:= 'INSERT INTO ' ||  l_interco_btab || ' (' || l_interco_col || ', value_set_display_code, status)
          SELECT ';

Line: 680

               ( SELECT ' || l_interco_col || '
                  FROM ' || l_interco_b || '
                  WHERE value_set_id = ' || l_interco_value_setid  || ' );' ;

Line: 688

          INSERT INTO ' || l_interco_tltab || ' (' || l_interco_col || ', value_set_display_code, status, language, description, ';

Line: 690

          SELECT cctr_org_display_code, ''' || l_interco_value_set ;

Line: 695

               ( SELECT ' || l_interco_col || '
                  FROM ' || l_interco_b || '
                  WHERE value_set_id = ' || l_interco_value_setid  || ' );' ;

Line: 711

  body := 'INSERT INTO ' || l_interco_attrtab || ' (' || l_interco_col ;

Line: 713

           SELECT ';

Line: 719

               ( SELECT ' || l_interco_col || '
                  FROM ' || l_interco_b || '
                  WHERE value_set_id = ' || l_interco_value_setid  || ' );' ;

Line: 727

    INSERT INTO ' || l_interco_attrtab || ' (' || l_interco_col ;

Line: 729

    SELECT ';

Line: 735

               ( SELECT ' || l_interco_col || '
                  FROM ' || l_interco_b || '
                  WHERE value_set_id = ' || l_interco_value_setid  || ' );' ;