DBA Data[Home] [Help]

APPS.BSC_DIM_FILTERS_PUB dependencies on BSC_TAB_INDICATORS

Line 127: FROM BSC_TAB_INDICATORS A

123: , x_msg_data OUT NOCOPY VARCHAR2
124: ) IS
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

Line 412: FROM BSC_TAB_INDICATORS A

408: ) RETURN VARCHAR2
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