APPS.BSC_UPDATE_DIM dependencies on BSC_SYS_BENCHMARKS_TL

Line 2302: -- Delete from BSC_SYS_BENCHMARKS_B and BSC_SYS_BENCHMARKS_TL the

2298: -- isc_plan_snapshot_v does not exists so we cannot import dbi plans
2299: RETURN TRUE;
2300: END IF;
2301:
2302: -- Delete from BSC_SYS_BENCHMARKS_B and BSC_SYS_BENCHMARKS_TL the
2303: -- DBI plans that are no longer valid.
2304: l_sql := 'DELETE FROM bsc_sys_benchmarks_b'||
2305: ' WHERE source_type = :1'||
2306: ' AND data_type NOT IN ('||

Line 2311: DELETE FROM bsc_sys_benchmarks_tl

2307: ' SELECT id FROM isc_plan_snapshot_v'||
2308: ')';
2309: EXECUTE IMMEDIATE l_sql USING 2;
2310:
2311: DELETE FROM bsc_sys_benchmarks_tl
2312: WHERE bm_id NOT IN (SELECT bm_id FROM bsc_sys_benchmarks_b);
2313:
2314: -- Insert new dbi plans into BSC_SYS_BENCHMARKS and BSC_SYS_BENCHMARKS_TL
2315: -- Added s.id < 1000 for bug#6713924

Line 2314: -- Insert new dbi plans into BSC_SYS_BENCHMARKS and BSC_SYS_BENCHMARKS_TL

2310:
2311: DELETE FROM bsc_sys_benchmarks_tl
2312: WHERE bm_id NOT IN (SELECT bm_id FROM bsc_sys_benchmarks_b);
2313:
2314: -- Insert new dbi plans into BSC_SYS_BENCHMARKS and BSC_SYS_BENCHMARKS_TL
2315: -- Added s.id < 1000 for bug#6713924
2316: l_num_ids := 0;
2317: l_sql := 'SELECT s.id, s.value'||
2318: ' FROM isc_plan_snapshot_v s, bsc_sys_benchmarks_b b'||