APPS.BSC_MIGRATION dependencies on BSC_SYS_DIM_LEVELS_TL

Line 705: -- BSC_SYS_DIM_LEVELS_TL

701: ' WHERE '||h_condition||
702: ' )';
703: BSC_APPS.Execute_Immediate(h_sql);
704:
705: -- BSC_SYS_DIM_LEVELS_TL
706: h_sql := 'DELETE FROM bsc_sys_dim_levels_tl'||
707: ' WHERE dim_level_id IN ('||
708: ' SELECT dim_level_id'||
709: ' FROM bsc_sys_dim_levels_b'||

Line 706: h_sql := 'DELETE FROM bsc_sys_dim_levels_tl'||

702: ' )';
703: BSC_APPS.Execute_Immediate(h_sql);
704:
705: -- BSC_SYS_DIM_LEVELS_TL
706: h_sql := 'DELETE FROM bsc_sys_dim_levels_tl'||
707: ' WHERE dim_level_id IN ('||
708: ' SELECT dim_level_id'||
709: ' FROM bsc_sys_dim_levels_b'||
710: ' WHERE '||h_condition||

Line 3482: g_metadata_tables(g_num_metadata_tables).table_name := 'BSC_SYS_DIM_LEVELS_TL';

3478: g_metadata_tables(g_num_metadata_tables).copy_flag := TRUE;
3479: g_metadata_tables(g_num_metadata_tables).lang_flag := FALSE;
3480:
3481: g_num_metadata_tables := g_num_metadata_tables + 1;
3482: g_metadata_tables(g_num_metadata_tables).table_name := 'BSC_SYS_DIM_LEVELS_TL';
3483: g_metadata_tables(g_num_metadata_tables).level := 0;
3484: g_metadata_tables(g_num_metadata_tables).level_column := NULL;
3485: g_metadata_tables(g_num_metadata_tables).level_condition := 'DIM_LEVEL_ID IN ('||
3486: ' SELECT DIM_LEVEL_ID'||

Line 9277: bsc_sys_dim_levels_tl tl,

9273: SET
9274: attribute_label_long = (SELECT
9275: tl.name
9276: FROM
9277: bsc_sys_dim_levels_tl tl,
9278: bsc_sys_dim_levels_b b
9279: WHERE
9280: b.short_name = l_Dim_Lev_Sht_Name AND
9281: b.dim_level_id = tl.dim_level_id AND