DBA Data[Home] [Help]

APPS.BSC_BSC_ADAPTER dependencies on BSC_KPI_DATA_TABLES_V

Line 2911: FROM bsc_kpi_data_tables_v WHERE (table_name = p_table OR

2907: p_num_filter_first_level:=0;
2908: --logic taken from BSC_UPDATE_CALC.apply_filters(x_table_name); 115.21 2003/03/25
2909: begin
2910: SELECT indicator, dim_set_id into l_indicator_id,l_dim_set_id
2911: FROM bsc_kpi_data_tables_v WHERE (table_name = p_table OR
2912: table_name = (SELECT DISTINCT table_name FROM bsc_db_calculations WHERE
2913: parameter1 = p_table AND calculation_type = 5)) and rownum=1;
2914: exception when NO_DATA_FOUND then
2915: l_indicator_id:=null;