APPS.BSC_CAUSE_EFFECT_UI_WRAPPER dependencies on BSC_SYS_MEASURES

Line 210: FROM bsc_sys_measures

206: INTO l_count
207: FROM bsc_sys_datasets_b
208: WHERE measure_id1 = (
209: SELECT measure_id
210: FROM bsc_sys_measures
211: WHERE short_name = p_measure_short_name);
212:
213: IF l_count > 0 THEN
214: RETURN TRUE;

Line 233: FROM bsc_sys_measures

229: SELECT dataset_id INTO l_dataset_id
230: FROM bsc_sys_datasets_b
231: WHERE measure_id1 = (
232: SELECT measure_id
233: FROM bsc_sys_measures
234: WHERE short_name = p_measure_short_name);
235:
236: RETURN l_dataset_id;
237: END Get_Dataset_Id;

Line 377: ' WHERE measure_id1 = (SELECT measure_id FROM bsc_sys_measures'||

373: IF p_level = 'KPI' THEN
374: l_sql := 'SELECT name FROM bsc_kpis_vl WHERE indicator = :i';
375: ELSE
376: l_sql := 'SELECT name FROM bsc_sys_datasets_vl'||
377: ' WHERE measure_id1 = (SELECT measure_id FROM bsc_sys_measures'||
378: ' WHERE short_name = :i)';
379: END IF;
380:
381: OPEN l_cursor FOR l_sql USING p_indicator;

Line 443: FROM bsc_sys_measures

439: -- For now we suppose that id the measure is at dataset level, it is a PMF measure
440:
441: -- Get measure short name
442: SELECT short_name INTO l_measure_short_name
443: FROM bsc_sys_measures
444: WHERE measure_id = (SELECT measure_id1 FROM bsc_sys_datasets_b WHERE dataset_id = p_indicator);
445:
446: -- Get the function name and region of the report of the measure
447: l_measure_rec.Measure_Short_Name := l_measure_short_name;