APPS.BSC_UTILITY SQL Statements

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

Line: 50

 |  Insert_Into_Query_Table                                                  |
 |      -- An API to insert into the PL/SQL table.                           |
 |  Do_DDL_AT                                                                |
 |      -- Autonously call DDL statements, used in our case for creating     |
 |         and dropping views                                                |
 |  Validate_Sql_String                                                      |
 |      -- Validate's if a SQL string is ok by creating a view               |
 |  Sort_String                                                              |
 |     -- sorts a comma separated string values                              |
 |                                                                           |
 |  17-JAN-2005 adrao  modified Validate_Plsql for Bug#4957841               |
 |  24-JAN-2006 ankgoel  Bug#4954663 Show Info text for AG to PL/SQL or VB conversion|
 |  15-FEB-2006 adrao   Bug#5034549; Added ABS() to DBMS_UTILITY.GET_TIME,   |

Line: 94

    update_edw_flag()

 PRIVATE PROCEDURES/FUNCTIONS
    exec_dynamic_sql()
    create_synonym_for_edw_time_m()

 PRIVATE PROCEDURES/FUNCTIONS

 EXTERNAL PROCEDURES/FUNCTIONS ACCESSED

 HISTORY
 15-JAN-1999    Srinivasan Jandyala Created
 22-JAN-1999    Alex Yang           Added Do_SQL() procedure.
 29-MAR-2001    Srini               Added PUBLIC PROCEDURE update_edw_flag(),
                                    PRIVATE PROCEDURE
                                    create_synonym_for_edw_time_m().
 27-Apr-2001    Srini               Added PUBLIC FUNCTION is_edw_installed().
 21-DEC-2001    Mario-Jair Campos   Added procedures:  get_dataset_id
                                                       get_kpi_dim_levels
 27-DEC-2001    Srini               Added function:get_kpi_dim_level_short_names
 23-APR-2003    mdamle              Added the Add_To_Fnd_Msg_Stack
 06-AUG-2003    mdamle              Added token-value to add_to_fnd_msg_stack
 08-FEB-2006    akoduri             Bug#4956836 Updating dim object cache should
                                    invalidate AK Cache also
----------------------------------------------------------------------------*/

-----------------------------------------------------------------------------
-- Private Variables
-----------------------------------------------------------------------------
   debug_flag boolean := false;

Line: 380

        SELECT
            synonym_name
        INTO
            l_object_name
        FROM
            ALL_SYNONYMS
        WHERE
            TABLE_NAME  = 'EDW_TIME_M'
        AND owner       = BSC_APPS.get_user_schema;

Line: 474

        SELECT
            object_name
        INTO
            l_object_name
        FROM
            user_objects
        WHERE
            object_name = l_edw_obj_name
        AND object_type IN ('VIEW', 'SYNONYM');

Line: 504

    l_sql_stmt := 'SELECT dim_id FROM edw_dimensions_md_v WHERE ROWNUM < 2';

Line: 531

        SELECT
            object_name
        INTO
            l_object_name
        FROM
            user_objects
        WHERE
            object_name = l_bsc_obj_name
        AND object_type = 'PACKAGE BODY';

Line: 597

PROCEDURE update_edw_flag(
            h_call_proc_name  IN VARCHAR2,
            h_mode            IN VARCHAR2) IS

-- Local variables

-- Objects to check for.

l_edw_obj_name      VARCHAR2(30)   := 'EDW_DIMENSIONS_MD_V';

Line: 628

        SELECT
            object_name
        INTO
            l_object_name
        FROM
            user_objects
        WHERE
            object_name = l_edw_obj_name
        AND object_type IN ('VIEW', 'SYNONYM');

Line: 646

                x_message => 'update_edw_flag(ENABLE): '||l_message,
                x_source  => l_call_proc,
                x_type    => 1,
                x_mode    => 'I' );

Line: 659

    l_sql_stmt := 'SELECT dim_id FROM edw_dimensions_md_v WHERE ROWNUM < 2';

Line: 672

                x_message => 'update_edw_flag(ENABLE): '||l_message,
                x_source  => l_call_proc,
                x_type    => 1,
                x_mode    => 'I' );

Line: 688

        SELECT
            object_name
        INTO
            l_object_name
        FROM
            user_objects
        WHERE
            object_name = l_bsc_obj_name
        AND object_type = 'PACKAGE BODY';

Line: 706

                x_message => 'update_edw_flag(ENABLE): '||l_message,
                x_source  => l_call_proc,
                x_type    => 1,
                x_mode    => 'I' );

Line: 717

    BEGIN       -- Update EDW_INSTALLED flag

        UPDATE bsc_sys_init
        SET    property_value = 'TRUE'
        WHERE  property_code  = l_property_code
        AND    property_value = 'FALSE';

Line: 730

                x_message => 'update_edw_flag(ENABLE): '||SQLERRM,
                x_source  => l_call_proc,
                x_type    => 1,
                x_mode    => 'I' );

Line: 737

    END;        -- Update EDW_INSTALLED flag

Line: 759

        SELECT
            indicator
        INTO
            l_count
        FROM
            bsc_kpis_vl
        WHERE
            edw_flag = 1
        AND ROWNUM   < 2;

Line: 775

                x_message => 'update_edw_flag(DISABLE): '||SQLERRM,
                x_source  => l_call_proc,
                x_type    => 1,
                x_mode    => 'I' );

Line: 788

      BEGIN       -- Update EDW_INSTALLED flag

        UPDATE bsc_sys_init
        SET    property_value = 'FALSE'
        WHERE  property_code  = l_property_code
        AND    property_value = 'TRUE';

Line: 803

                x_message => 'update_edw_flag(ENABLE): '||SQLERRM,
                x_source  => l_call_proc,
                x_type    => 1,
                x_mode    => 'I' );

Line: 808

      END;        -- Update EDW_INSTALLED flag

Line: 812

        l_message := BSC_UPDATE_UTIL.Get_Message('BSC_EDW_DISABLE');

Line: 833

            x_message => 'update_edw_flag(): '||l_message,
            x_source  => l_call_proc,
            x_mode    => 'I' );

Line: 845

            x_message => 'update_edw_flag: '||SQLERRM,
            x_source  => l_call_proc,
            x_mode    => 'I' );

Line: 851

END update_edw_flag;

Line: 889

  l_sql := ' select distinct dataset_id ' ||
           '   from BSC_KPI_ANALYSIS_MEASURES_B ' ||
           '  where indicator = :1 '||
           '    and ' || l_column || ' = : 2' ;

Line: 920

    SELECT DISTINCT NAME
    FROM   BSC_KPI_DIM_LEVELS_TL
    WHERE  INDICATOR    = p_kpi_id
    AND    DIM_SET_ID   = p_dim_set_id;

Line: 946

    SELECT DISTINCT Level_ShortName
    FROM   BSC_KPI_DIM_LEVELS_VL
    WHERE  INDICATOR    = p_kpi_id
    AND    DIM_SET_ID   = p_dim_set_id;

Line: 976

  select to_char(last_update_date, 'DD-MON-YYYY-HH24-MI-SS')
    into l_timestamp
    from BSC_SYS_INIT
   where property_code = 'LOCK_SYSTEM';

Line: 1022

  select userenv('SESSIONID')
    into l_session_id
    from dual;

Line: 1026

  select count(message)
    into l_count
    from BSC_MESSAGE_LOGS
   where type = 0
     and upper(source) = 'BSC_SECURITY.CHECK_SYSTEM_LOCK'
     and last_update_login =  l_session_id;

Line: 1036

    select message
      into l_message
      from BSC_MESSAGE_LOGS
     where type = 0
       and upper(source) = 'BSC_SECURITY.CHECK_SYSTEM_LOCK'
       and last_update_login =  l_session_id;

Line: 1187

    SELECT FND_PROFILE.VALUE('BSC_INTERNAL_USER') INTO l_internal FROM DUAL;

Line: 1246

        select replace(translate(l_tempalias,'0123456789.','???????????'), '?', '')
        into l_isNumber
        from dual;

Line: 1278

  l_sql := 'SELECT COUNT(1) FROM '|| p_Table_Name || ' WHERE ' || p_Column_Name ||' = :1';

Line: 1294

    l_sql := 'SELECT COUNT(1) FROM '|| p_Table_Name || ' WHERE ' || p_Column_Name ||' = :1';

Line: 1317

    SELECT  Property_Value
    FROM    BSC_SYS_INIT
    WHERE   PROPERTY_CODE ='SYSTEM_STAGE';

Line: 1357

    SELECT COUNT(*) INTO l_Count
    FROM   ALL_MVIEWS
    WHERE  MVIEW_NAME = l_Tab_Name
    AND OWNER = BSC_APPS.get_user_schema;

Line: 1383

    SELECT COUNT(0) INTO l_Count
    FROM   ALL_VIEWS
    WHERE  VIEW_NAME = l_Tab_Name
    AND OWNER = BSC_APPS.get_user_schema('APPS');

Line: 1409

    SELECT COUNT(0) INTO l_Count
    FROM   ALL_TABLES
    WHERE  TABLE_NAME = l_Tab_Name
    AND OWNER = get_owner_for_object(p_Table_Name);

Line: 1453

  SELECT object_type
  FROM user_objects
  WHERE object_name =  c_object_name;

Line: 1459

  SELECT table_owner
  FROM user_synonyms
  WHERE synonym_name = c_syn_name;

Line: 1514

    SELECT PROTOTYPE_FLAG
    FROM   BSC_KPIS_B
    WHERE  INDICATOR = p_Kpi_Id;

Line: 1596

  SELECT FND_PROFILE.VALUE(c_ADV_SUMMARIZATION_LEVEL)
  INTO   l_Profile_Value
  FROM   DUAL;

Line: 1628

  SELECT property_value
  INTO l_Profile_Value
  FROM BSC_SYS_INIT
  WHERE property_code = 'ADV_SUM_LEVEL';

Line: 1698

  SELECT  DISTINCT(sys.source)  source
  FROM    bsc_sys_dim_levels_b sys,
          bsc_kpi_dim_level_properties kpi
  WHERE   sys.dim_level_id = kpi.dim_level_id
  AND     kpi.INDICATOR = p_Kpi_Id
  AND     kpi.dim_set_id = p_Dim_Set_Id;

Line: 1713

      SELECT short_name
      INTO l_Short_Name
      FROM  BSC_KPIS_B
      WHERE indicator= p_Kpi_Id;

Line: 1726

    SELECT COUNT(0) into l_count
    FROM (
    (SELECT dim_level_index
    FROM   bsc_kpi_dim_levels_b
    WHERE  INDICATOR = p_kpi_id
    AND    dim_set_id = p_dim_set_id )
    MINUS
    ((SELECT DISTINCT (parent_level_index)
    FROM   bsc_kpi_dim_levels_b
    WHERE  INDICATOR = p_kpi_id
    AND    dim_set_id = p_dim_set_id
    AND    parent_level_index IS NOT NULL)
    UNION
    (SELECT  dim_level_index
    FROM    bsc_kpi_dim_levels_b
    WHERE   INDICATOR = p_kpi_id
    AND     dim_set_id = p_dim_set_id
    AND     parent_level_index IS NOT NULL)));

Line: 1775

    SELECT NVL(MAX(dataset_id) + 1, 0)
    INTO   l_next
    FROM   BSC_SYS_DATASETS_TL;

Line: 1781

    SELECT NVL(MAX(dim_group_id) + 1, 0)
    INTO   l_next
    FROM   BSC_SYS_DIM_GROUPS_TL;

Line: 1787

    SELECT NVL(MAX(dim_level_id) + 1, 0)
    INTO   l_next
    FROM   BSC_SYS_DIM_LEVELS_B;

Line: 1909

   SELECT COUNT(1) INTO l_Count
   FROM   BSC_SYS_INIT B
   WHERE  B.PROPERTY_CODE  = c_MIXED_DIM_OBJS
   AND    B.PROPERTY_VALUE > 0;

Line: 1939

    SELECT COUNT(1)
    INTO   l_count
    FROM   BSC_SYS_DIM_LEVELS_B
    WHERE  Level_Table_Name = l_table_name
    AND short_name <> p_short_name ;

Line: 1970

    l_Sql := ' SELECT COUNT(1) ' ||
             ' FROM BSC_SYS_CALENDARS_B BC, BSC_SYS_PERIODICITIES BP ' ||
             ' WHERE  BC.SHORT_NAME  = :1 AND BP.SHORT_NAME  = :2 ' ||
             ' AND    BP.CALENDAR_ID = BC.CALENDAR_ID ';

Line: 2003

  l_sql := ' SELECT COUNT(1) ' ||
           ' FROM BSC_SYS_CALENDARS_B BC ' ||
           ' WHERE  BC.SHORT_NAME  = :1 ';

Line: 2032

    l_Sql := ' SELECT COUNT(1) ' ||
             ' FROM BSC_SYS_PERIODICITIES BP ' ||
             ' WHERE BP.SHORT_NAME = :1 ' ;

Line: 2156

        SELECT NAME
        INTO l_name
        FROM BSC_SYS_DIM_LEVELS_VL
        WHERE SHORT_NAME = p_Entity_Short_Name;

Line: 2161

        SELECT NAME
        INTO l_name
        FROM BSC_SYS_DIM_GROUPS_VL
        WHERE SHORT_NAME = p_Entity_Short_Name;

Line: 2217

    SELECT COUNT(1) INTO l_Count
    FROM   BSC_SYS_DIM_GROUPS_VL B
         , BSC_KPIS_B            K
         , BSC_KPI_DIM_GROUPS    G
    WHERE B.SHORT_NAME = p_Short_Name
    AND   K.SHORT_NAME = B.SHORT_NAME
    AND   G.INDICATOR  = K.INDICATOR;

Line: 2237

    SELECT COUNT(1)
    INTO l_Count
    FROM BSC_SYS_DIM_GROUPS_VL d,
    BSC_KPI_DIM_GROUPS k
    WHERE d.DIM_GROUP_ID = k.DIM_GROUP_ID
    AND BSC_BIS_DIMENSION_PUB.Get_Dimension_Source(d.SHORT_NAME)=BSC_UTILITY.c_PMF
    AND d.SHORT_NAME=p_Short_Name;

Line: 2258

    SELECT COUNT(1)
    INTO l_Count
    FROM ak_regions
    WHERE attribute_category = BSC_UTILITY.C_ATTRIBUTE_CATEGORY
    AND attribute10 = BSC_UTILITY.C_REPORT_TYPE_MDS
    AND attribute12 = p_Short_Name;

Line: 2277

    SELECT COUNT(1)
    INTO l_Count
    FROM ak_regions
    WHERE attribute_category = BSC_UTILITY.C_ATTRIBUTE_CATEGORY
    AND attribute10 = BSC_UTILITY.C_REPORT_TYPE_TABLE
    AND attribute12 = p_Short_Name;

Line: 2288

    SELECT COUNT(1)
    INTO l_Count
    FROM ak_regions
    WHERE attribute_category = BSC_UTILITY.C_ATTRIBUTE_CATEGORY
    AND attribute10 IS NULL
    AND attribute12 = p_Short_Name;

Line: 2328

        l_Sql := ' SELECT COUNT(1) FROM BIS_LEVELS L, BSC_SYS_PERIODICITIES P '
                 || ' WHERE L.SHORT_NAME = :1 '
                 || ' AND   P.SHORT_NAME = L.SHORT_NAME ';

Line: 2347

        l_Sql :=   ' SELECT COUNT(1) FROM BIS_DIMENSIONS D, BSC_SYS_CALENDARS_B C '
                 ||' WHERE D.SHORT_NAME = :1 AND C.SHORT_NAME = D.SHORT_NAME  ';

Line: 2542

        l_sql := 'SELECT DISTINCT REGION_CODE FROM ak_region_items  WHERE node_query_flag = ''Y'' AND node_display_flag = ''N'' AND SUBSTR(attribute2,INSTR(attribute2,''+'') +1 ,LENGTH(attribute2)) IN (' ;

Line: 2591

    SELECT DISTINCT REGION_CODE
    FROM ak_region_items
    WHERE attribute2 LIKE p_Short_name ||'+%'
    AND attribute1 IN ('VIEWBY PARAMETER', 'DIMENSION LEVEL', 'DIM LEVEL SINGLE VALUE', 'HIDE VIEW BY DIMENSION');

Line: 2597

    SELECT region_code
    FROM ak_regions
    WHERE attribute12 = p_Short_Name;

Line: 2602

    SELECT DISTINCT REGION_CODE
    FROM ak_region_items
    WHERE attribute2 = p_Short_name
    AND attribute1 IN ('VIEWBY PARAMETER', 'DIMENSION LEVEL', 'DIM LEVEL SINGLE VALUE', 'HIDE VIEW BY DIMENSION');

Line: 2655

  SELECT user_function_name FROM fnd_form_functions_vl
  WHERE parameters like '%pRegionCode='|| p_Region_Code ||'%'
  AND rownum < 2;

Line: 2660

  SELECT name FROM ak_regions_vl
  WHERE region_code = p_Region_Code;

Line: 2682

    SELECT F.RESPONSIBILITY_KEY INTO l_Resp_Key
    FROM   FND_RESPONSIBILITY F
    WHERE  F.RESPONSIBILITY_ID = FND_GLOBAL.RESP_ID
    AND    F.APPLICATION_ID    = FND_GLOBAL.RESP_APPL_ID;

Line: 2699

    SELECT COUNT(1) INTO l_Count
    FROM   BIS_INDICATORS B
    WHERE  B.SHORT_NAME = p_Short_Name
    AND    BIS_UTIL.is_Seeded(B.CREATED_BY,'Y','N') = 'Y';

Line: 2990

        SELECT A.LINE, A.TEXT
        FROM   ALL_SOURCE A
        WHERE  A.OWNER = BSC_APPS.get_user_schema(C_PACKAGE_OWNER)
        AND    A.TYPE  = C_PACKAGE_SPECIFICATION
        AND    A.NAME  = l_Package_Name;

Line: 3143

    SELECT COUNT(1) INTO l_Count
    FROM   ALL_SOURCE A
    WHERE  A.TYPE  = C_PACKAGE_SPECIFICATION
    AND    A.OWNER = BSC_APPS.get_user_schema(C_PACKAGE_OWNER)
    AND    A.NAME  = l_Package_Name;

Line: 3157

    SELECT COUNT(1) INTO l_Count
    FROM   USER_OBJECTS A
    WHERE  A.OBJECT_NAME  = l_Package_Name
    AND    A.STATUS       = C_PACKAGE_STATUS_INVALID;

Line: 3313

          Insert_Into_Query_Table(l_PMV_Query_Table
                                  ,'BIS_CURRENT_ASOF_DATE'
                                  ,i
                                  ,l_Default_Values(i)
                                  ,NULL
                                  ,NULL
                                  ,NULL
          );

Line: 3321

          Insert_Into_Query_Table(l_PMV_Query_Table
                                  ,'AS_OF_DATE'
                                  ,i
                                  ,l_Default_Values(i)
                                  ,NULL
                                  ,NULL
                                  ,NULL
          );

Line: 3332

            Insert_Into_Query_Table(l_PMV_Query_Table
                                    ,'BIS_CURRENT_EFFECTIVE_END_DATE'
                                    ,i
                                    ,l_Default_Values(i)
                                    ,NULL
                                    ,NULL
                                    ,NULL
            );

Line: 3341

            Insert_Into_Query_Table(l_PMV_Query_Table
                                    ,'BIS_CURRENT_EFFECTIVE_END_DATE'
                                    ,i
                                    ,l_Default_Values(i)
                                    ,NULL
                                    ,NULL
                                    ,NULL
            );

Line: 3350

            Insert_Into_Query_Table(l_PMV_Query_Table
                                    ,'BIS_PERIOD_TYPE'
                                    ,i
                                    ,SUBSTR(l_Attribute2(i), INSTR(l_Attribute2(i),'+') + 1)
                                    ,NULL
                                    ,NULL
                                    ,NULL
            );

Line: 3359

            Insert_Into_Query_Table(l_PMV_Query_Table
                                    ,'_LOCAL_TIME_PARAM'
                                    ,i
                                    ,l_Default_Values(i)
                                    ,NULL
                                    ,NULL
                                    ,NULL
            );

Line: 3368

            Insert_Into_Query_Table(l_PMV_Query_Table
                                    ,l_Attribute2(i) || '_FROM'
                                    ,i
                                    ,l_Default_Values(i)
                                    ,NULL
                                    ,NULL
                                    ,NULL
            );

Line: 3377

            Insert_Into_Query_Table(l_PMV_Query_Table
                                    ,l_Attribute2(i) || '_TO'
                                    ,i
                                    ,l_Default_Values(i)
                                    ,NULL
                                    ,NULL
                                    ,NULL
            );

Line: 3386

            Insert_Into_Query_Table(l_PMV_Query_Table
                                    ,l_Attribute2(i) || '_PFROM'
                                    ,i
                                    ,l_Default_Values(i)
                                    ,NULL
                                    ,NULL
                                    ,NULL
            );

Line: 3395

            Insert_Into_Query_Table(l_PMV_Query_Table
                                    ,l_Attribute2(i) || '_PTO'
                                    ,i
                                    ,l_Default_Values(i)
                                    ,NULL
                                    ,NULL
                                    ,NULL
            );

Line: 3408

            Insert_Into_Query_Table(l_PMV_Query_Table
                                    ,'BIS_TIME_COMPARISON_TYPE'
                                    ,i
                                    ,l_Comparison_Type
                                    ,NULL
                                    ,NULL
                                    ,NULL
            );

Line: 3417

            Insert_Into_Query_Table(l_PMV_Query_Table
                                    ,'TIME_COMPARISON_TYPE'
                                    ,i
                                    ,l_Comparison_Type
                                    ,NULL
                                    ,NULL
                                    ,NULL
            );

Line: 3427

            Insert_Into_Query_Table(l_PMV_Query_Table
                                    ,l_Attribute2(i)
                                    ,i
                                    ,l_Default_Values(i)
                                    ,NULL
                                    ,NULL
                                    ,NULL
            );

Line: 3437

            Insert_Into_Query_Table(l_PMV_Query_Table
                                    ,'BIS_SELECTED_TOP_MANAGER'
                                    ,i
                                    ,l_Default_Values(i)
                                    ,NULL
                                    ,NULL
                                    ,NULL
            );

Line: 3448

        Insert_Into_Query_Table(l_PMV_Query_Table
                                ,l_Attribute1(i)
                                ,i
                                ,l_Default_Values(i)
                                ,NULL
                                ,NULL
                                ,NULL
        );

Line: 3485

    Insert_Into_Query_Table(l_PMV_Query_Table
                            ,'BIS_FXN_NAME'
                            ,NULL
                            ,p_Region_Code
                            ,NULL
                            ,NULL
                            ,NULL
    );

Line: 3494

    Insert_Into_Query_Table(l_PMV_Query_Table
                            ,'BIS_REGION_CODE'
                            ,NULL
                            ,p_Region_Code
                            ,NULL
                            ,NULL
                            ,NULL
    );

Line: 3503

    Insert_Into_Query_Table(l_PMV_Query_Table
                            ,'BIS_ICX_SESSION_ID'
                            ,NULL
                            ,'-1'
                            ,NULL
                            ,NULL
                            ,NULL
    );

Line: 3560

PROCEDURE Insert_Into_Query_Table (
    x_Param_Table IN OUT NOCOPY BIS_PMV_PAGE_PARAMETER_TBL
  , p_Parameter_Name  IN VARCHAR2
  , p_Parameter_Id    IN VARCHAR2
  , p_Parameter_Value IN VARCHAR2
  , p_Dimension       IN VARCHAR2
  , p_Period_Date     IN DATE
  , p_Operator        IN VARCHAR2
) IS
    l_Index NUMBER;

Line: 3585

END Insert_Into_Query_Table;

Line: 3630

    SELECT A.COLUMN_NAME
    FROM   ALL_TAB_COLS A
    WHERE  A.TABLE_NAME = l_Temp_View_Name
    AND    A.OWNER = BSC_APPS.get_user_schema(C_PACKAGE_OWNER)
    ORDER BY A.COLUMN_NAME;

Line: 3759

    SELECT COUNT(1)
      FROM bsc_kpis_b k, bsc_kpi_analysis_measures_b m
      WHERE k.indicator = m.indicator
      AND   m.dataset_id = p_dataset_id
      AND   k.short_name <> p_region_code;

Line: 3811

     SELECT COUNT(1)
       FROM bsc_sys_datasets_b d, bsc_sys_measures m
       WHERE d.dataset_id = p_dataset_id
       AND   m.measure_id = d.measure_id1
       AND  ((BSC_BIS_MEASURE_PUB.Is_Formula_Type(m.measure_Col) = 'T') OR
             (d.measure_id2 IS NOT NULL) OR
             (BSC_UTILITY.Is_Src_Col_In_Formulas(m.measure_Col) = 'T') OR
             ((SELECT COUNT(1) FROM bsc_sys_datasets_b
                 WHERE dataset_id <> d.dataset_id
         AND   (measure_id1 = d.measure_id1 OR measure_id2 = d.measure_id1)) > 0)
            );

Line: 3957

    SELECT measure_type
    INTO   l_measure_type
    FROM   bis_indicators
    WHERE  short_name = p_Measure_Short_Name;

Line: 3984

  SELECT  COUNT(0)
  INTO    l_count
  FROM    bis_target_levels tl,
          bis_indicators    i
  WHERE   i.dataset_id    = p_Dataset_Id
  AND     tl.indicator_id = i.indicator_id;

Line: 4010

    SELECT measure_type
    INTO   l_measure_type
    FROM   bis_indicators
    WHERE  dataset_id = p_dataset_id;

Line: 4039

  SELECT short_name
  INTO   l_region_code
  FROM   bsc_kpis_b
  WHERE  indicator =p_Indicator;

Line: 4044

  SELECT short_name
  INTO   l_meas_short_name
  FROM   bis_indicators
  WHERE  dataset_id =p_Dataset_Id;

Line: 4072

    SELECT measure_type
    INTO   l_measure_type
    FROM   bis_indicators
    WHERE  dataset_id = p_dataset_id;

Line: 4101

  SELECT short_name
  INTO   l_attribute2
  FROM   bis_indicators
  WHERE  dataset_id =p_dataset_id;

Line: 4106

  SELECT COUNT(1)
  INTO   l_count
  FROM   ak_region_items a,
         ak_regions b
  WHERE  a.region_code = b.region_code
  AND    a.attribute1 IN (BSC_UTILITY.C_ATTRTYPE_MEASURE,BSC_UTILITY.C_ATTRTYPE_MEASURE_NO_TARGET,BSC_UTILITY.C_BUCKET_MEASURE,BSC_UTILITY.C_SUB_MEASURE)
  AND    a.attribute2  = l_attribute2
  AND    b.attribute10 = BSC_UTILITY.C_MULTIPLE_DATA_SOURCE;

Line: 4137

SELECT day30, MONTH
FROM bsc_db_calendar
WHERE calendar_id = p_calid
AND   calendar_year =  p_cyear
MINUS
SELECT day30, MONTH
FROM bsc_db_calendar
WHERE calendar_id = p_calid
AND   calendar_year = p_pyear;

Line: 4155

   SELECT day365
   INTO x_result
   FROM bsc_db_calendar
   WHERE calendar_id = p_calid
   AND  calendar_year = p_cyear
   AND  day30 = lday
   AND  MONTH = lmonth;