APPS.BSC_MO_LOADER_CONFIG_PKG dependencies on BSC_KPI_DATA_TABLES_V

Line 288: FROM BSC_KPI_DATA_TABLES_V

284: end_year NUMBER;
285:
286: CURSOR c1 IS
287: SELECT DISTINCT TABLE_NAME, PERIODICITY_ID
288: FROM BSC_KPI_DATA_TABLES_V
289: WHERE INDICATOR = indic
290: AND TABLE_NAME IS NOT NULL;
291: l_temp NUMBER;
292: BEGIN

Line 512: SELECT DISTINCT TABLE_NAME FROM BSC_KPI_DATA_TABLES_V

508: arrIndicTables OUT NOCOPY DBMS_SQL.VARCHAR2_TABLE, numIndicTables OUT NOCOPY NUMBER) IS
509:
510: l_STMT VARCHAR2(1000);
511: CURSOR C1 (p1 NUMBER, p2 NUMBER) IS
512: SELECT DISTINCT TABLE_NAME FROM BSC_KPI_DATA_TABLES_V
513: WHERE INDICATOR = p1
514: AND DIM_SET_ID = p2
515: AND TABLE_NAME IS NOT NULL;
516:

Line 521: FROM BSC_KPI_DATA_TABLES_V

517: CURSOR c2 (p1 NUMBER, p2 NUMBER) IS
518: SELECT DISTINCT SOURCE_TABLE_NAME FROM BSC_DB_TABLES_RELS
519: WHERE TABLE_NAME IN (
520: SELECT TABLE_NAME
521: FROM BSC_KPI_DATA_TABLES_V
522: WHERE INDICATOR = p1
523: AND DIM_SET_ID = p2
524: AND TABLE_NAME IS NOT NULL)
525: AND RELATION_TYPE = 1;