APPS.BSC_UPDATE_COLOR dependencies on BSC_SYS_DIM_LEVELS_B

Line 2101: ' FROM BSC_SYS_COM_DIM_LEVELS C, BSC_SYS_DIM_LEVELS_B D'||

2097: h_sql := 'INSERT /*+ append */ INTO BSC_TMP_TAB_DEF'||
2098: ' SELECT C.TAB_ID, C.DIM_LEVEL_INDEX,'||
2099: ' D.LEVEL_PK_COL, D.LEVEL_VIEW_NAME,'||
2100: ' 0 AS FAMILY_INDEX, 0 AS DIM_INDEX'||
2101: ' FROM BSC_SYS_COM_DIM_LEVELS C, BSC_SYS_DIM_LEVELS_B D'||
2102: ' WHERE C.DIM_LEVEL_ID = D.DIM_LEVEL_ID';
2103: BSC_UPDATE_UTIL.Execute_Immediate(h_sql);
2104: commit;
2105:

Line 2416: FROM bsc_sys_dim_levels_b e, bsc_sys_dim_level_rels r

2412: h_cursor t_cursor;
2413:
2414: cursor c_pl_dimension_info ( pLevelPkCol varchar2) is
2415: SELECT e.level_view_name, r.relation_col
2416: FROM bsc_sys_dim_levels_b e, bsc_sys_dim_level_rels r
2417: WHERE e.dim_level_id = r.dim_level_id AND
2418: e.level_pk_col = pLevelPkCol ;
2419:
2420: h_pl_account_table_name VARCHAR2(30);