APPS.BSC_DIM_FILTERS_PUB dependencies on BSC_SYS_FILTERS_VIEWS

Line 39: FROM BSC_SYS_FILTERS_VIEWS

35: l_Tab_Id NUMBER;
36: -- Cursor to get all tab with filter views
37: CURSOR c_Tabs_With_Filters IS
38: SELECT DISTINCT Source_Code -- Distinct need it
39: FROM BSC_SYS_FILTERS_VIEWS
40: WHERE Source_Type = BSC_DIM_FILTERS_PUB.SOURCE_TYPE_TAB;
41:
42: BEGIN
43: SAVEPOINT CheckFiltersNotApply;

Line 129: , BSC_SYS_FILTERS_VIEWS C

125: CURSOR c_Filters_Tab IS
126: SELECT DISTINCT C.Source_Code
127: FROM BSC_TAB_INDICATORS A
128: , BSC_KPIS_B B
129: , BSC_SYS_FILTERS_VIEWS C
130: WHERE A.Indicator = B.Indicator
131: AND C.Source_Type = BSC_DIM_FILTERS_PUB.Source_Type_Tab
132: AND C.Source_Code = A.Tab_Id
133: AND ((B.Indicator = p_kpi_id) OR (B.Source_Indicator = p_kpi_id));

Line 279: FROM BSC_SYS_FILTERS_VIEWS

275:
276: -- SQL to get the Tab_Ids where the dimension has filters
277: CURSOR c_Tabs_With_Current_Dim_Obj IS
278: SELECT Source_Code TAB_ID
279: FROM BSC_SYS_FILTERS_VIEWS
280: WHERE Dim_Level_Id = p_Dim_Level_Id;
281: BEGIN
282: --DBMS_OUTPUT.PUT_LINE(' BEGIN Drop_Filter_By_Dim_Obj ');
283: --DBMS_OUTPUT.PUT_LINE(' p_Dim_Level_Id = ' || p_Dim_Level_Id);

Line 344: FROM BSC_SYS_FILTERS_VIEWS

340:
341: -- Cursors to get the Dim_Obj with firters in the current tab
342: CURSOR c_dim_filters IS
343: SELECT Dim_Level_Id
344: FROM BSC_SYS_FILTERS_VIEWS
345: WHERE Source_Code = p_Tab_Id;
346:
347: l_Dim_Level_id NUMBER;
348: BEGIN

Line 413: , BSC_SYS_FILTERS_VIEWS B

409: IS
410: CURSOR c_Filter_View_Name IS
411: SELECT B.Level_View_Name
412: FROM BSC_TAB_INDICATORS A
413: , BSC_SYS_FILTERS_VIEWS B
414: WHERE A.Indicator = p_Kpi_Id
415: AND B.Dim_Level_Id = p_Dim_Level_Id
416: AND B.Source_Code = A.Tab_Id
417: AND B.Source_Type = BSC_DIM_FILTERS_PUB.Source_Type_Tab;