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_PERIODICITIES

Line 179: (SELECT periodicity_id FROM bsc_sys_periodicities);

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);
183:

Line 182: (SELECT periodicity_id FROM bsc_sys_periodicities);

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);
186: END;

Line 184: DELETE bsc_sys_periodicities WHERE calendar_id NOT IN

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);
186: END;
187:
188: FUNCTION check_dangling_records RETURN BOOLEAN IS

Line 194: (SELECT periodicity_id FROM bsc_sys_periodicities);

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;
198: END IF;

Line 201: (SELECT periodicity_id FROM bsc_sys_periodicities);

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;
205: END IF;

Line 207: SELECT COUNT(1) INTO h_count from bsc_sys_periodicities WHERE calendar_id NOT IN

203: IF h_count > 0 THEN
204: h_dangling_true := TRUE;
205: END IF;
206:
207: SELECT COUNT(1) INTO h_count from bsc_sys_periodicities WHERE calendar_id NOT IN
208: (SELECT calendar_id FROM bsc_sys_calendars_b);
209:
210: IF h_count > 0 THEN
211: h_dangling_true := TRUE;