DBA Data[Home] [Help]

APPS.BSC_DBGEN_METADATA_READER dependencies on BSC_KPIS_VL

Line 31: select name from bsc_kpis_vl

27: /*CURSOR cSource IS
28: select object_name from BSC_DB_FACT_KPI_MAPS
29: where indicator= p_fact_id;*/
30: CURSOR cSource IS
31: select name from bsc_kpis_vl
32: where indicator= p_fact_id;
33: l_name VARCHAR2(1000);
34: BEGIN
35: OPEN cSource;

Line 49: select name, 1, 'BSC' from BSC_KPIS_VL

45: select object_name, object_type, source from BSC_DB_FACT_KPI_MAPS
46: where indicator= p_fact_id;
47: */
48: CURSOR cSource IS
49: select name, 1, 'BSC' from BSC_KPIS_VL
50: where indicator= p_fact_id;
51: BEGIN
52: OPEN cSource;
53: FETCH cSource INTO p_fact, p_fact_type, p_fact_source;