APPS.BSC_BIA_WRAPPER dependencies on BSC_DB_TABLES_COLS

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 320: -- I have added the condition on source in bsc_db_tables_cols

316: -- Fix bug#5069433 Use bulk collect
317:
318: -- SUPPORT_BSC_BIS_MEASURES: Only BSC measures exists in bsc_db_measure_cols_vl and
319: -- by design we assumed that BIS measures do not have projection.
320: -- I have added the condition on source in bsc_db_tables_cols
321:
322: IF g_projection_kpis_set IS NULL OR g_projection_kpis_set = FALSE THEN
323: g_projection_kpis.delete;
324: OPEN c1('A','BSC','BSC',0,0);