[Home] [Help]
593: INTO
594: l_Bsc_Measure_Id
595: FROM
596: bsc_sys_measures m,
597: bsc_sys_datasets_vl d,
598: bis_indicators i
599: WHERE
600: i.dataset_id = d.dataset_id AND
601: d.measure_id1 = m.measure_id AND
4958: INTO
4959: l_Measure_Source
4960: FROM
4961: bsc_sys_measures m,
4962: bsc_sys_datasets_vl d,
4963: bis_indicators i
4964: WHERE
4965: i.dataset_id = d.dataset_id AND
4966: d.measure_id1 = m.measure_id AND
5308: INTO
5309: l_Bsc_Measure_Id
5310: FROM
5311: bsc_sys_measures m,
5312: bsc_sys_datasets_vl d,
5313: bis_indicators i
5314: WHERE
5315: i.dataset_id = d.dataset_id AND
5316: d.measure_id1 = m.measure_id AND
5912: M.SHORT_NAME,
5913: D.FORMAT_ID
5914: FROM BSC_KPI_ANALYSIS_MEASURES_VL A,
5915: BIS_INDICATORS M,
5916: BSC_SYS_DATASETS_VL D
5917: WHERE A.ANALYSIS_OPTION0 >= p_Deleted_AO_Index
5918: AND A.ANALYSIS_OPTION1 = 0
5919: AND A.ANALYSIS_OPTION2 = 0
5920: AND A.SERIES_ID = 0
6487: INTO
6488: l_Count
6489: FROM
6490: bsc_sys_measures m,
6491: bsc_sys_datasets_vl d,
6492: bis_indicators i
6493: WHERE
6494: i.dataset_id = d.dataset_id AND
6495: d.measure_id1 = m.measure_id AND
7167: BEGIN
7168: BEGIN
7169: SELECT NAME
7170: INTO x_Kpi_Name
7171: FROM BSC_SYS_DATASETS_VL
7172: WHERE DATASET_ID = Get_Dataset_Id(p_Measure_Short_Name);
7173: EXCEPTION
7174: WHEN OTHERS THEN
7175: x_Kpi_Name := NULL;
8361: INTO
8362: l_Count
8363: FROM
8364: bsc_sys_measures m,
8365: bsc_sys_datasets_vl d,
8366: bis_indicators i
8367: WHERE
8368: i.dataset_id = d.dataset_id AND
8369: d.measure_id1 = m.measure_id AND
8966: INTO
8967: l_Measure_Source
8968: FROM
8969: bsc_sys_measures m,
8970: bsc_sys_datasets_vl d,
8971: bis_indicators i
8972: WHERE
8973: i.dataset_id = d.dataset_id AND
8974: d.measure_id1 = m.measure_id AND
10768: SELECT
10769: m.measure_col, m.measure_id
10770: FROM
10771: bsc_sys_measures m,
10772: bsc_sys_datasets_vl d,
10773: bis_indicators i
10774: WHERE
10775: i.dataset_id = d.dataset_id AND
10776: d.measure_id1 = m.measure_id AND