APPS.BSC_DBGEN_BSC_READER dependencies on BSC_KPI_DATA_TABLES

Line 1798: select distinct mv_name from bsc_kpi_data_tables

1794: p_fact IN VARCHAR2,
1795: p_dim_set IN NUMBER)
1796: return dbms_sql.varchar2_table is
1797: cursor cList is
1798: select distinct mv_name from bsc_kpi_data_tables
1799: where indicator = to_number(p_fact)
1800: and dim_set_id = p_dim_set
1801: and mv_name not like 'BSC_S_%ZMV';
1802: l_mv_list dbms_sql.varchar2_table ;

Line 2436: FROM bsc_kpi_data_tables

2432: p_dim_set IN NUMBER)
2433: return dbms_sql.varchar2_table is
2434: cursor cList is
2435: SELECT DISTINCT mv_name
2436: FROM bsc_kpi_data_tables
2437: WHERE indicator = to_number(p_fact)
2438: AND dim_set_id = p_dim_set
2439: AND mv_name like 'BSC%ZMV';
2440: l_mv_list dbms_sql.varchar2_table ;