APPS.BSC_TIME_DIM_TEST dependencies on BSC_SYS_PERIODS_TL

Line 178: DELETE bsc_sys_periods_tl WHERE periodicity_id NOT IN

174: END;
175:
176: PROCEDURE correct_dangling_records IS
177: BEGIN
178: DELETE bsc_sys_periods_tl WHERE periodicity_id NOT IN
179: (SELECT periodicity_id FROM bsc_sys_periodicities);
180:
181: DELETE bsc_sys_periods WHERE periodicity_id NOT IN
182: (SELECT periodicity_id FROM bsc_sys_periodicities);

Line 193: SELECT COUNT(1) INTO h_count from bsc_sys_periods_tl WHERE periodicity_id NOT IN

189: h_count NUMBER;
190: h_dangling_true BOOLEAN;
191: BEGIN
192: h_dangling_true := FALSE;
193: SELECT COUNT(1) INTO h_count from bsc_sys_periods_tl WHERE periodicity_id NOT IN
194: (SELECT periodicity_id FROM bsc_sys_periodicities);
195:
196: IF h_count > 0 THEN
197: h_dangling_true := TRUE;