APPS.BSC_TIME_DIM_TEST SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 61

        JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;

Line: 64

        SELECT COUNT(1) INTO h_fii_cnt FROM FII_TIME_DAY;

Line: 99

        SELECT COUNT(1) INTO h_count FROM all_indexes
        WHERE index_name = 'BSC_DB_CALENDAR_U1'
        AND OWNER = l_oracle_schema;

Line: 115

        sqltxt := 'SELECT start_month||''/''||start_day||''/''||current_year "START_DATE",edw_calendar_id FROM'||
                   ' bsc_sys_calendars_b WHERE edw_calendar_type_id=1 AND edw_calendar_id IN (1001,1002,1003)';

Line: 178

        DELETE bsc_sys_periods_tl WHERE periodicity_id NOT IN
        (SELECT periodicity_id  FROM bsc_sys_periodicities);

Line: 181

        DELETE bsc_sys_periods WHERE periodicity_id NOT IN
        (SELECT periodicity_id  FROM bsc_sys_periodicities);

Line: 184

        DELETE bsc_sys_periodicities WHERE calendar_id NOT IN
        (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
        (SELECT periodicity_id  FROM bsc_sys_periodicities);

Line: 200

        SELECT COUNT(1) INTO h_count from bsc_sys_periods WHERE periodicity_id NOT IN
        (SELECT periodicity_id  FROM bsc_sys_periodicities);

Line: 207

        SELECT COUNT(1) INTO h_count from bsc_sys_periodicities WHERE calendar_id NOT IN
        (SELECT calendar_id FROM bsc_sys_calendars_b);