DBA Data[Home] [Help]

APPS.BSC_UTILITY dependencies on BSC_KPI_ANALYSIS_MEASURES_B

Line 857: BSC_KPI_ANALYSIS_MEASURES_B handles analysis option ids, it has different

853: -----------------------------------------------------------------------------
854:
855: /* The following function is used to get the dataset id for an analysis
856: option. A function is needed to do this because of the way
857: BSC_KPI_ANALYSIS_MEASURES_B handles analysis option ids, it has different
858: columns for the different analysis groups. This Function in a way
859: normalizes these columns.
860: Parameters for the function are: BSC KPI Id, Analysis Option group Id,
861: Analysis Option Id.

Line 890: ' from BSC_KPI_ANALYSIS_MEASURES_B ' ||

886: l_column := 'analysis_option2';
887: end if;
888:
889: l_sql := ' select distinct dataset_id ' ||
890: ' from BSC_KPI_ANALYSIS_MEASURES_B ' ||
891: ' where indicator = :1 '||
892: ' and ' || l_column || ' = : 2' ;
893:
894: open dc_value for l_sql using p_kpi_id,p_option_id;

Line 3760: FROM bsc_kpis_b k, bsc_kpi_analysis_measures_b m

3756: l_obj_count NUMBER;
3757:
3758: CURSOR c_attached_obj IS
3759: SELECT COUNT(1)
3760: FROM bsc_kpis_b k, bsc_kpi_analysis_measures_b m
3761: WHERE k.indicator = m.indicator
3762: AND m.dataset_id = p_dataset_id
3763: AND k.short_name <> p_region_code;
3764: