DBA Data[Home] [Help]

APPS.BSC_CAUSE_EFFECT_UI_WRAPPER dependencies on BSC_SYS_DATASETS_B

Line 207: FROM bsc_sys_datasets_b

203: l_count NUMBER := 0;
204: BEGIN
205: SELECT count(*)
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);

Line 230: FROM bsc_sys_datasets_b

226: ) RETURN NUMBER IS
227: l_dataset_id NUMBER;
228: BEGIN
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);

Line 444: WHERE measure_id = (SELECT measure_id1 FROM bsc_sys_datasets_b WHERE dataset_id = p_indicator);

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;
448: BIS_MEASURE_PUB.Retrieve_Measure(