APPS.BSC_OAF_VIEWS_PVT SQL Statements

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

Line: 61

    SELECT INDICATOR_TYPE,CONFIG_TYPE
    FROM BSC_KPIS_B
    WHERE INDICATOR=X_INDICATOR;

Line: 71

    SELECT MAX( ANALYSIS_GROUP_ID)
    INTO h_ag_count
    FROM BSC_KPI_ANALYSIS_GROUPS
    WHERE INDICATOR=X_INDICATOR;

Line: 80

    SELECT NAME
    INTO h_a0_name
    FROM BSC_KPI_ANALYSIS_OPTIONS_VL
    WHERE ANALYSIS_GROUP_ID =0 AND
    OPTION_ID=X_A0 AND
    INDICATOR=X_INDICATOR;

Line: 93

        SELECT DEPENDENCY_FLAG
        INTO h_ag1_depend
        FROM BSC_KPI_ANALYSIS_GROUPS
        WHERE ANALYSIS_GROUP_ID =1 AND
        INDICATOR=X_INDICATOR;

Line: 104

            SELECT NAME
            INTO h_a1_name
            FROM BSC_KPI_ANALYSIS_OPTIONS_VL
            WHERE ANALYSIS_GROUP_ID =1 AND
            OPTION_ID=X_A1 AND
            INDICATOR=X_INDICATOR;

Line: 113

                SELECT NAME
                INTO h_a1_name
                FROM BSC_KPI_ANALYSIS_OPTIONS_VL
                WHERE ANALYSIS_GROUP_ID =1 AND
                OPTION_ID=X_A1 AND
                PARENT_OPTION_ID = X_A0 AND
                INDICATOR=X_INDICATOR;

Line: 122

                SELECT COUNT(*)
                INTO l_al_count
                FROM BSC_KPI_ANALYSIS_OPTIONS_VL
                WHERE ANALYSIS_GROUP_ID =1 AND
                PARENT_OPTION_ID = X_A0 AND
                INDICATOR =X_INDICATOR;

Line: 160

        SELECT DEPENDENCY_FLAG
        INTO h_ag2_depend
        FROM BSC_KPI_ANALYSIS_GROUPS
        WHERE ANALYSIS_GROUP_ID =2 AND
        INDICATOR=X_INDICATOR;

Line: 168

            SELECT NAME
            INTO h_a2_name
            FROM BSC_KPI_ANALYSIS_OPTIONS_VL
            WHERE ANALYSIS_GROUP_ID =2 AND
            OPTION_ID=X_A2 AND
            INDICATOR=X_INDICATOR;

Line: 180

                SELECT NAME
                INTO h_a2_name
                FROM BSC_KPI_ANALYSIS_OPTIONS_VL
                WHERE ANALYSIS_GROUP_ID =2 AND
                OPTION_ID=X_A2 AND
                PARENT_OPTION_ID = X_A1 AND
                INDICATOR=X_INDICATOR;

Line: 190

                SELECT COUNT(*)
                INTO l_al_count
                FROM BSC_KPI_ANALYSIS_OPTIONS_VL
                WHERE ANALYSIS_GROUP_ID =2 AND
                PARENT_OPTION_ID = X_A1 AND
                INDICATOR =X_INDICATOR;

Line: 204

                SELECT NAME
                INTO h_a2_name
                FROM BSC_KPI_ANALYSIS_OPTIONS_VL
                WHERE ANALYSIS_GROUP_ID =2 AND
                OPTION_ID=X_A2 AND
                PARENT_OPTION_ID = X_A1 AND
                GRANDPARENT_OPTION_ID = X_A0 AND
                INDICATOR=X_INDICATOR;

Line: 214

                SELECT COUNT(*)
                INTO l_al_count
                FROM BSC_KPI_ANALYSIS_OPTIONS_VL
                WHERE ANALYSIS_GROUP_ID =2 AND
                PARENT_OPTION_ID = X_A1 AND
                GRANDPARENT_OPTION_ID = X_A0 AND
                INDICATOR =X_INDICATOR;

Line: 254

            SELECT COUNT(*) VAL
            INTO h_series_count
            FROM BSC_KPI_ANALYSIS_MEASURES_VL
            WHERE  ANALYSIS_OPTION0 =X_A0 AND
            ANALYSIS_OPTION1 =X_A1 AND
            ANALYSIS_OPTION2 =X_A2 AND
            INDICATOR=X_INDICATOR;

Line: 262

                SELECT NAME
                INTO h_series_name
                FROM BSC_KPI_ANALYSIS_MEASURES_VL
                WHERE  ANALYSIS_OPTION0 =X_A0 AND
                ANALYSIS_OPTION1 =X_A1 AND
                ANALYSIS_OPTION2 =X_A2 AND
                SERIES_ID = X_SERIES_ID AND
                INDICATOR=X_INDICATOR;

Line: 339

    SELECT DISTINCT DF.A0_DEFAULT,DF.A1_DEFAULT,DF.A2_DEFAULT,MS.SERIES_ID
    INTO d_A0,d_A1,d_A2,d_SERIES_ID
    FROM BSC_DB_COLOR_AO_DEFAULTS_V DF,
         BSC_KPI_ANALYSIS_MEASURES_B MS
    WHERE
    DEFAULT_VALUE =1 AND
    DF.INDICATOR = MS.INDICATOR AND
    DF.A0_DEFAULT = MS.ANALYSIS_OPTION0 AND
    DF.A1_DEFAULT = MS.ANALYSIS_OPTION1 AND
    DF.A2_DEFAULT = MS.ANALYSIS_OPTION2 AND
    DF.INDICATOR =X_INDICATOR;

Line: 358

    SELECT NVL(DS.SOURCE,'BSC') VAL
    INTO h_measure_source
    FROM  BSC_KPI_ANALYSIS_MEASURES_B MS,
    BSC_SYS_DATASETS_B DS
    WHERE
    ANALYSIS_OPTION0 =X_A0 AND
    ANALYSIS_OPTION1 =X_A1 AND
    ANALYSIS_OPTION2 =X_A2 AND
    SERIES_ID = X_SERIES_ID AND
    MS.DATASET_ID = DS.DATASET_ID AND
    MS.INDICATOR =X_INDICATOR;

Line: 371

    SELECT DECODE(PROTOTYPE_FLAG,
            0,'FALSE',
            5,'FALSE',
            6,'FALSE',
              'TRUE') PROTOTYPE
    INTO h_kpi_prototype
    FROM BSC_KPIS_B
    WHERE INDICATOR =X_INDICATOR;

Line: 416

  select indicator_type,config_type
    from BSC_KPIS_B
   where indicator = x_indicator;

Line: 439

  select max(analysis_group_id)
    into h_ag_count
    from BSC_KPI_ANALYSIS_GROUPS
   where indicator = x_indicator;

Line: 447

  select default_value
    into l_def_flag0
    from BSC_KPI_ANALYSIS_GROUPS
   where indicator = x_indicator
     and analysis_group_id = 0;

Line: 454

  select user_level1
    into l_disp_flag0
    from BSC_KPI_ANALYSIS_OPTIONS_VL
   where analysis_group_id = 0
     and option_id = x_a0
     and indicator = x_indicator;

Line: 472

    select dependency_flag, default_value
      into h_ag1_depend, l_def_flag1
      from BSC_KPI_ANALYSIS_GROUPS
     where analysis_group_id = 1
       and indicator = x_indicator;

Line: 482

      select user_level1
        into l_disp_flag1
        from BSC_KPI_ANALYSIS_OPTIONS_VL
       where analysis_group_id = 1
         and option_id = x_a1
         and indicator = x_indicator;

Line: 499

        select user_level1
          into l_disp_flag1
          from BSC_KPI_ANALYSIS_OPTIONS_VL
     where analysis_group_id = 1
           and option_id = x_a1
           and parent_option_id = x_a0
           and indicator = x_indicator;

Line: 531

    select dependency_flag, default_value
      into h_ag2_depend, l_def_flag2
      from BSC_KPI_ANALYSIS_GROUPS
     where analysis_group_id = 2
       and indicator = x_indicator;

Line: 541

      select user_level1
      into l_disp_flag2
      from BSC_KPI_ANALYSIS_OPTIONS_VL
      where analysis_group_id = 2
      and option_id = x_a2
      and indicator = x_indicator;

Line: 560

      select user_level1
        into l_disp_flag2
        from BSC_KPI_ANALYSIS_OPTIONS_VL
       where analysis_group_id = 2
             and option_id = x_a2
             and parent_option_id = x_a1
             and indicator=x_indicator;

Line: 583

      select user_level1
        into l_disp_flag2
        from BSC_KPI_ANALYSIS_OPTIONS_VL
       where analysis_group_id = 2
             and option_id = x_a2
             and parent_option_id = x_a1
             and grandparent_option_id = x_a0
             and indicator = x_indicator;

Line: 609

  select count(indicator)
    into l_simul_tree
    from BSC_KPIS_B
   where indicator = x_indicator
     and indicator_type = 1
     and config_type = 7;

Line: 619

    select count(a.option_id)
      into l_def_opt_count
      from BSC_KPI_ANALYSIS_OPTIONS_B a,
           BSC_KPI_ANALYSIS_GROUPS b
     where a.indicator = x_indicator
       and a.indicator = b.indicator
       and a.analysis_group_id = b.analysis_group_id
       and a.option_id = b.default_value
       and a.user_level1 = 1;

Line: 668

    SELECT PL.NAME
     FROM BSC_SYS_DIM_LEVEL_RELS LR,
              BSC_SYS_DIM_LEVELS_VL PL
     WHERE LR.DIM_LEVEL_ID = p_level_id
               AND PL.DIM_LEVEL_ID = PARENT_DIM_LEVEL_ID;

Line: 717

    SELECT DISTINCT DF.A0_DEFAULT,DF.A1_DEFAULT,DF.A2_DEFAULT,MS.SERIES_ID
    INTO d_A0,d_A1,d_A2,d_SERIES_ID
    FROM BSC_DB_COLOR_AO_DEFAULTS_V DF,
         BSC_KPI_ANALYSIS_MEASURES_B MS
    WHERE
    DEFAULT_VALUE =1 AND
    DF.INDICATOR = MS.INDICATOR AND
    DF.A0_DEFAULT = MS.ANALYSIS_OPTION0 AND
    DF.A1_DEFAULT = MS.ANALYSIS_OPTION1 AND
    DF.A2_DEFAULT = MS.ANALYSIS_OPTION2 AND
    DF.INDICATOR =X_INDICATOR;

Line: 747

  SELECT COUNT(*) INTO l_Count
  FROM   BSC_TABS_VL
  WHERE  Parent_Tab_Id = p_tab_id;

Line: 771

|   Parameters:    X_DATASET_ID     Menu Id that will be inserted
+============================================================================*/
FUNCTION  GET_DATASET_SOURCE(X_DATASET_ID in NUMBER
    ) RETURN VARCHAR2 IS

l_tmp VARCHAR2(10);

Line: 782

         SELECT NVL(SOURCE,'BSC') SOURCE
         into l_tmp
         FROM BSC_SYS_DATASETS_B
         WHERE
         DATASET_ID = X_DATASET_ID;