APPS.BSC_BSC_ADAPTER dependencies on BSC_TAB_INDICATORS

Line 3116: and source_code in (select tab_id from bsc_tab_indicators where indicator=p_ind);

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
3119: select 1 from bsc_sys_filters where source_type=p_type and source_code=p_code
3120: and dim_level_id=p_id and rownum=1;

Line 3128: 'level_table_name=:1 and source_code in (select tab_id from bsc_tab_indicators where indicator=:2';

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);
3132: fetch c3 into p_source_type,p_source_code,p_dim_level_id;