APPS.BSC_BSC_ADAPTER dependencies on BSC_SYS_DIM_LEVEL_COLS

Line 6189: from bsc_sys_dim_level_cols ,bsc_sys_dim_levels_b

6185: l_stmt varchar2(5000);
6186: ---------------------------------------------
6187: cursor c1 (p_level_table_name varchar2)
6188: is select column_name,column_type
6189: from bsc_sys_dim_level_cols ,bsc_sys_dim_levels_b
6190: where level_table_name=p_level_table_name
6191: and bsc_sys_dim_level_cols.dim_level_id=bsc_sys_dim_levels_b.dim_level_id;
6192: ---------------------------------------------
6193: Begin

Line 6191: and bsc_sys_dim_level_cols.dim_level_id=bsc_sys_dim_levels_b.dim_level_id;

6187: cursor c1 (p_level_table_name varchar2)
6188: is select column_name,column_type
6189: from bsc_sys_dim_level_cols ,bsc_sys_dim_levels_b
6190: where level_table_name=p_level_table_name
6191: and bsc_sys_dim_level_cols.dim_level_id=bsc_sys_dim_levels_b.dim_level_id;
6192: ---------------------------------------------
6193: Begin
6194: if g_debug then
6195: l_stmt:='select column_name,column_type '||

Line 6196: 'from bsc_sys_dim_level_cols ,bsc_sys_dim_levels_b '||

6192: ---------------------------------------------
6193: Begin
6194: if g_debug then
6195: l_stmt:='select column_name,column_type '||
6196: 'from bsc_sys_dim_level_cols ,bsc_sys_dim_levels_b '||
6197: 'where level_table_name=:1 '||
6198: 'and bsc_sys_dim_level_cols.dim_level_id=bsc_sys_dim_levels_b.dim_level_id ';
6199: write_to_log_file_n(l_stmt||' '||p_level);
6200: end if;

Line 6198: 'and bsc_sys_dim_level_cols.dim_level_id=bsc_sys_dim_levels_b.dim_level_id ';

6194: if g_debug then
6195: l_stmt:='select column_name,column_type '||
6196: 'from bsc_sys_dim_level_cols ,bsc_sys_dim_levels_b '||
6197: 'where level_table_name=:1 '||
6198: 'and bsc_sys_dim_level_cols.dim_level_id=bsc_sys_dim_levels_b.dim_level_id ';
6199: write_to_log_file_n(l_stmt||' '||p_level);
6200: end if;
6201: p_number_columns:=1;
6202: open c1(p_level);