APPS.BSC_BSC_ADAPTER dependencies on BSC_SYS_FILTERS_VIEWS

Line 3114: select source_type,source_code,dim_level_id from bsc_sys_filters_views where

3110: p_dim_level_id out nocopy number
3111: ) return number is
3112: ----
3113: cursor c3(p_ind number, p_table_name varchar2) is
3114: select source_type,source_code,dim_level_id from bsc_sys_filters_views where
3115: level_table_name=p_table_name
3116: and source_code in (select tab_id from bsc_tab_indicators where indicator=p_ind);
3117: ----
3118: cursor c4(p_type number,p_code number,p_id number) is

Line 3127: l_stmt:='select source_type,source_code,dim_level_id from bsc_sys_filters_views where '||

3123: l_stmt varchar2(8000);
3124: --------------------------------
3125: Begin
3126: if g_debug then
3127: l_stmt:='select source_type,source_code,dim_level_id from bsc_sys_filters_views where '||
3128: 'level_table_name=:1 and source_code in (select tab_id from bsc_tab_indicators where indicator=:2';
3129: write_to_log_file_n(l_stmt||' '||p_level||' '||p_indicator);
3130: end if;
3131: open c3(p_indicator, p_level);