APPS.BSC_DIM_FILTERS_PUB SQL Statements

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

Line: 38

    SELECT  DISTINCT Source_Code   -- Distinct need it
    FROM    BSC_SYS_FILTERS_VIEWS
    WHERE   Source_Type = BSC_DIM_FILTERS_PUB.SOURCE_TYPE_TAB;

Line: 126

    SELECT DISTINCT C.Source_Code
    FROM   BSC_TAB_INDICATORS     A
         , BSC_KPIS_B             B
         , BSC_SYS_FILTERS_VIEWS  C
    WHERE  A.Indicator    = B.Indicator
    AND    C.Source_Type  = BSC_DIM_FILTERS_PUB.Source_Type_Tab
    AND    C.Source_Code  = A.Tab_Id
    AND    ((B.Indicator  = p_kpi_id) OR (B.Source_Indicator = p_kpi_id));

Line: 187

      Delete a Filter View a and make cascading delete for child dimension Filter views
-------------------------------------------------------------------------------------------------------------------*/
PROCEDURE  Drop_Filter
(       p_Tab_Id            IN      NUMBER
    ,   p_Dim_Level_Id      IN      NUMBER
    ,   x_return_status     OUT NOCOPY     VARCHAR2
    ,   x_msg_COUNT         OUT NOCOPY     NUMBER
    ,   x_msg_data          OUT NOCOPY     VARCHAR2
) IS

BEGIN

        BSC_DIM_FILTERS_PVT.Drop_Filter  (
                        p_Tab_Id        => p_Tab_Id
                    ,   p_Dim_Level_Id  => p_Dim_Level_Id
                    ,   x_return_status => x_return_status
                    ,   x_msg_COUNT     => x_msg_COUNT
                    ,   x_msg_data      => x_msg_data
       );

Line: 278

    SELECT  Source_Code     TAB_ID
    FROM    BSC_SYS_FILTERS_VIEWS
    WHERE   Dim_Level_Id = p_Dim_Level_Id;

Line: 343

    SELECT  Dim_Level_Id
    FROM    BSC_SYS_FILTERS_VIEWS
    WHERE   Source_Code = p_Tab_Id;

Line: 411

    SELECT B.Level_View_Name
    FROM   BSC_TAB_INDICATORS     A
         , BSC_SYS_FILTERS_VIEWS  B
    WHERE  A.Indicator     =  p_Kpi_Id
    AND    B.Dim_Level_Id  =  p_Dim_Level_Id
    AND    B.Source_Code   =  A.Tab_Id
    AND    B.Source_Type   =  BSC_DIM_FILTERS_PUB.Source_Type_Tab;