APPS.BSC_DIM_FILTERS_PVT dependencies on BSC_DIM_FILTERS_PUB

Line 37: WHERE Source_Type = BSC_DIM_FILTERS_PUB.SOURCE_TYPE_TAB

33: BEGIN
34: SELECT Level_View_Name
35: INTO l_Level_View_Nane
36: FROM BSC_SYS_FILTERS_VIEWS
37: WHERE Source_Type = BSC_DIM_FILTERS_PUB.SOURCE_TYPE_TAB
38: AND Source_Code = p_Tab_Id
39: AND Dim_Level_Id = p_Dim_Level_Id;
40:
41: RETURN l_Level_View_Nane;

Line 66: WHERE TF.Source_Type = BSC_DIM_FILTERS_PUB.SOURCE_TYPE_TAB

62:
63: CURSOR c_Filters_Not_Apply IS
64: SELECT TF.Dim_Level_Id
65: FROM BSC_SYS_FILTERS_VIEWS TF
66: WHERE TF.Source_Type = BSC_DIM_FILTERS_PUB.SOURCE_TYPE_TAB
67: AND TF.Source_Code = p_Tab_Id
68: AND TF.Dim_Level_Id NOT IN
69: ( SELECT SL.Dim_Level_Id
70: FROM BSC_TAB_INDICATORS TI

Line 297: WHERE Source_Type = BSC_DIM_FILTERS_PUB.SOURCE_TYPE_TAB

293: ----DBMS_OUTPUT.PUT_LINE(' Drop_Filter p_Dim_Level_Id = ' || p_Dim_Level_Id );
294:
295: --Delete Filter Level View metadata
296: DELETE FROM BSC_SYS_FILTERS_VIEWS
297: WHERE Source_Type = BSC_DIM_FILTERS_PUB.SOURCE_TYPE_TAB
298: AND Source_Code = p_Tab_Id
299: AND Dim_Level_Id = p_Dim_Level_Id;
300:
301: ----DBMS_OUTPUT.PUT_LINE(' DELETE FROM BSC_SYS_FILTERS_VIEWS ' );

Line 305: WHERE Source_Type = BSC_DIM_FILTERS_PUB.SOURCE_TYPE_TAB

301: ----DBMS_OUTPUT.PUT_LINE(' DELETE FROM BSC_SYS_FILTERS_VIEWS ' );
302:
303: -- Delete Filter Level Values metadata
304: DELETE FROM BSC_SYS_FILTERS
305: WHERE Source_Type = BSC_DIM_FILTERS_PUB.SOURCE_TYPE_TAB
306: AND Source_Code = p_Tab_Id
307: AND Dim_Level_Id = p_Dim_Level_Id;
308:
309: ----DBMS_OUTPUT.PUT_LINE(' BSC_SYS_FILTERS ' );

Line 394: WHERE A.Source_Type = BSC_DIM_FILTERS_PUB.SOURCE_TYPE_TAB

390: , BSC_SYS_DIM_LEVELS_B SD
391: , (
392: SELECT *
393: FROM BSC_SYS_FILTERS_VIEWS A
394: WHERE A.Source_Type = BSC_DIM_FILTERS_PUB.SOURCE_TYPE_TAB
395: AND A.Source_Code = p_Tab_Id
396: ) FV
397: WHERE TI.Tab_Id = p_Tab_Id
398: AND KD.INDICATOR = TI.INDICATOR