APPS.BSC_SYNC_MVLOGS dependencies on BSC_SYS_DIM_LEVELS_B

Line 64: from bsc_sys_dim_levels_b lvl

60: l_length number;
61:
62: cursor cCol is
63: select level_pk_col, cols.data_type, cols.data_length
64: from bsc_sys_dim_levels_b lvl
65: , all_tab_columns cols
66: where lvl.level_table_name=p_level
67: and lvl.level_table_name = cols.table_name
68: and lvl.level_pk_col = cols.column_name

Line 97: from bsc_sys_dim_levels_b lvl

93: where master = p_level and log_owner = p_owner;
94:
95: cursor cCols(p_mv_log varchar2) is
96: select cols.column_name, cols.data_type, cols.data_length
97: from bsc_sys_dim_levels_b lvl
98: , all_tab_columns cols
99: where lvl.level_table_name = p_level
100: and lvl.level_table_name = cols.table_name
101: and cols.owner = p_owner