APPS.BSC_TIME_DIM_TEST dependencies on BSC_SYS_CALENDARS_B

Line 116: ' bsc_sys_calendars_b WHERE edw_calendar_type_id=1 AND edw_calendar_id IN (1001,1002,1003)';

112: RETURN ;
113: END IF;
114:
115: sqltxt := 'SELECT start_month||''/''||start_day||''/''||current_year "START_DATE",edw_calendar_id FROM'||
116: ' bsc_sys_calendars_b WHERE edw_calendar_type_id=1 AND edw_calendar_id IN (1001,1002,1003)';
117: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,BSC_OBJECTIVE_METADATA_SETUP.get_message_name('BSC_DBI_CAL_METADATA'));
118:
119: statusStr := 'WARNING';
120: errStr := BSC_OBJECTIVE_METADATA_SETUP.get_message_name('BSC_NEED_INVESTIGATION');

Line 185: (SELECT calendar_id FROM bsc_sys_calendars_b);

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
189: h_count NUMBER;

Line 208: (SELECT calendar_id FROM bsc_sys_calendars_b);

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