APPS.BSC_BIA_WRAPPER dependencies on BSC_KPI_DATA_TABLES

Line 307: FROM bsc_kpi_data_tables kt, bsc_db_tables_cols tc, bsc_db_measure_cols_vl m

303: ) RETURN BOOLEAN IS
304:
305: CURSOR c1 (p1 varchar2, p2 varchar2, p3 varchar2, p4 number, p5 number) IS
306: SELECT DISTINCT kt.indicator
307: FROM bsc_kpi_data_tables kt, bsc_db_tables_cols tc, bsc_db_measure_cols_vl m
308: WHERE kt.table_name = tc.table_name AND
309: tc.column_type = p1 AND
310: NVL(tc.source, p2) = p3 AND
311: tc.column_name = m.measure_col AND

Line 543: FROM BSC_KPI_DATA_TABLES

539:
540: -- Bug #3236356
541: CURSOR c_Kpi_For_MV IS
542: SELECT DISTINCT INDICATOR
543: FROM BSC_KPI_DATA_TABLES
544: WHERE MV_NAME = p_mv;
545:
546: -- Bug #3236356
547: CURSOR c_Kpi_For_SB_MV IS

Line 549: FROM BSC_KPI_DATA_TABLES T, BSC_DB_TABLES_RELS R

545:
546: -- Bug #3236356
547: CURSOR c_Kpi_For_SB_MV IS
548: SELECT DISTINCT T.INDICATOR
549: FROM BSC_KPI_DATA_TABLES T, BSC_DB_TABLES_RELS R
550: WHERE T.TABLE_NAME = R.TABLE_NAME
551: AND R.RELATION_TYPE = 1
552: AND BSC_BIA_WRAPPER.Get_Sum_Table_MV_Name(SOURCE_TABLE_NAME) = p_mv;
553: