eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BSC_TIME_DIM_TEST dependencies on BSC_SYS_PERIODS

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 181: DELETE bsc_sys_periods WHERE periodicity_id NOT IN

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);
183:
184: DELETE bsc_sys_periodicities WHERE calendar_id NOT IN
185: (SELECT calendar_id FROM bsc_sys_calendars_b);

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;

Line 200: SELECT COUNT(1) INTO h_count from bsc_sys_periods WHERE periodicity_id NOT IN

196: IF h_count > 0 THEN
197: h_dangling_true := TRUE;
198: END IF;
199:
200: SELECT COUNT(1) INTO h_count from bsc_sys_periods WHERE periodicity_id NOT IN
201: (SELECT periodicity_id FROM bsc_sys_periodicities);
202:
203: IF h_count > 0 THEN
204: h_dangling_true := TRUE;