APPS.BSC_DIMENSION_LEVELS_PVT dependencies on BSC_DB_TABLES

Line 316: --delete the enteries from BSC_DB_TABLES and BSC_DB_TABLES_RELS

312: --EXECUTE IMMEDIATE l_sql;
313: BSC_APPS.Do_Ddl_AT(l_sql, ad_ddl.drop_view, l_Dim_Level_Rec.Bsc_Level_Name, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);
314: end if;
315: ELSIF(l_Dim_Level_Rec.Bsc_Source = 'BSC') THEN
316: --delete the enteries from BSC_DB_TABLES and BSC_DB_TABLES_RELS
317: DELETE FROM BSC_DB_TABLES
318: WHERE Table_Name = 'BSC_DI_'||p_Dim_Level_Rec.Bsc_Level_Id;
319:
320: DELETE FROM BSC_DB_TABLES_RELS

Line 317: DELETE FROM BSC_DB_TABLES

313: BSC_APPS.Do_Ddl_AT(l_sql, ad_ddl.drop_view, l_Dim_Level_Rec.Bsc_Level_Name, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);
314: end if;
315: ELSIF(l_Dim_Level_Rec.Bsc_Source = 'BSC') THEN
316: --delete the enteries from BSC_DB_TABLES and BSC_DB_TABLES_RELS
317: DELETE FROM BSC_DB_TABLES
318: WHERE Table_Name = 'BSC_DI_'||p_Dim_Level_Rec.Bsc_Level_Id;
319:
320: DELETE FROM BSC_DB_TABLES_RELS
321: WHERE Source_Table_Name = 'BSC_DI_'||p_Dim_Level_Rec.Bsc_Level_Id;

Line 320: DELETE FROM BSC_DB_TABLES_RELS

316: --delete the enteries from BSC_DB_TABLES and BSC_DB_TABLES_RELS
317: DELETE FROM BSC_DB_TABLES
318: WHERE Table_Name = 'BSC_DI_'||p_Dim_Level_Rec.Bsc_Level_Id;
319:
320: DELETE FROM BSC_DB_TABLES_RELS
321: WHERE Source_Table_Name = 'BSC_DI_'||p_Dim_Level_Rec.Bsc_Level_Id;
322:
323: --DROP VIEW
324: l_view_name := 'BSC_D_'||l_Dim_Level_Rec.Bsc_Level_Id||'_VL';