APPS.BSC_OAF_VIEWS_PVT dependencies on BSC_SYS_DATASETS_B

Line 315: h_measure_source BSC_SYS_DATASETS_B.source%type;

311: ) RETURN VARCHAR2 is
312:
313: h_kpi_prototype VARCHAR2(10);
314: h_kpi_measure_source bsc_kpi_defaults_b.measure_source%TYPE;
315: h_measure_source BSC_SYS_DATASETS_B.source%type;
316: h_color bsc_kpis_b.prototype_color%TYPE;
317: h_RED bsc_kpis_b.prototype_color%TYPE;
318: h_GREEN bsc_kpis_b.prototype_color%TYPE;
319: h_YELLOW bsc_kpis_b.prototype_color%TYPE;

Line 361: BSC_SYS_DATASETS_B DS

357: --Bug #2660714
358: SELECT NVL(DS.SOURCE,'BSC') VAL
359: INTO h_measure_source
360: FROM BSC_KPI_ANALYSIS_MEASURES_B MS,
361: BSC_SYS_DATASETS_B DS
362: WHERE
363: ANALYSIS_OPTION0 =X_A0 AND
364: ANALYSIS_OPTION1 =X_A1 AND
365: ANALYSIS_OPTION2 =X_A2 AND

Line 784: FROM BSC_SYS_DATASETS_B

780: ELSE
781: l_tmp := 'BSC';
782: SELECT NVL(SOURCE,'BSC') SOURCE
783: into l_tmp
784: FROM BSC_SYS_DATASETS_B
785: WHERE
786: DATASET_ID = X_DATASET_ID;
787:
788: h_dataset := X_DATASET_ID;