[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
l_sql := 'select i.short_name, nvl(m.source, ''BSC'')'||
' from bsc_kpi_analysis_measures_b k, bsc_sys_datasets_b d, bsc_sys_measures m, bis_indicators i'||
' where k.indicator = :1 and k.analysis_option0 = :2 and'||
' k.analysis_option1 = :3 and k.analysis_option2 = :4 and'||
' k.series_id = :5 and k.dataset_id = d.dataset_id and'||
' d.measure_id1 = m.measure_id and m.short_name = i.short_name (+)';
l_sql := 'select count(1)'||
' from (select k.level_shortname'||
' from bsc_kpi_analysis_options_b a, bsc_kpi_dim_levels_vl k'||
' where a.indicator = :1 and a.analysis_group_id = 0 and'||
' a.option_id = :2 and a.parent_option_id = 0 and'||
' a.grandparent_option_id = 0 and a.indicator = k.indicator and'||
' a.dim_set_id = k.dim_set_id and k.level_source = ''PMF'')';
l_sql := 'select count(*)'||
' from (select k.level_shortname'||
' from bsc_kpi_analysis_options_b a, bsc_kpi_dim_levels_vl k,'||
' bisfv_dimension_levels dl, bisfv_performance_measures pm'||
' where a.indicator = :1 and a.analysis_group_id = 0 and'||
' a.option_id = :2 and a.parent_option_id = 0 and'||
' a.grandparent_option_id = 0 and a.indicator = k.indicator and'||
' a.dim_set_id = k.dim_set_id and k.level_source = ''PMF'' and'||
' k.level_shortname = dl.dimension_level_short_name and'||
' pm.measure_short_name = :3 and ('||
' dl.dimension_short_name = pm.dimension1_short_name or'||
' dl.dimension_short_name = pm.dimension2_short_name or'||
' dl.dimension_short_name = pm.dimension3_short_name or'||
' dl.dimension_short_name = pm.dimension4_short_name or'||
' dl.dimension_short_name = pm.dimension5_short_name or'||
' dl.dimension_short_name = pm.dimension6_short_name or'||
' dl.dimension_short_name = pm.dimension7_short_name))';