APPS.CSF_RMDUP SQL Statements

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

Line: 7

    select ADMIN_BOUND_ID, rowid
    from CSF_MD_ADM_BOUNDS
    where ADMIN_BOUND_ID >= start_id
    order by ADMIN_BOUND_ID;

Line: 31

        delete from CSF_MD_ADM_BOUNDS where rowid = r1.rowid;

Line: 51

    select hydrography_id, rowid
    from csf_md_hydros
    where hydrography_id >= start_id
    order by hydrography_id;

Line: 75

        delete from csf_md_hydros where rowid = r1.rowid;

Line: 95

    select INST_STYLE_ID, rowid
    from CSF_MD_INST_STYLE_SHTS
    where INST_STYLE_ID >= start_id
    order by INST_STYLE_ID;

Line: 119

        delete from CSF_MD_INST_STYLE_SHTS where rowid = r1.rowid;

Line: 139

    select LANDUSE_ID, rowid
    from CSF_MD_LAND_USES
    where LANDUSE_ID >= start_id
    order by LANDUSE_ID;

Line: 163

        delete from CSF_MD_LAND_USES where rowid = r1.rowid;

Line: 183

    select LAYER_METADATA_ID, rowid
    from CSF_MD_LYR_METADATA
    where LAYER_METADATA_ID >= start_id
    order by LAYER_METADATA_ID;

Line: 207

        delete from CSF_MD_LYR_METADATA where rowid = r1.rowid;

Line: 227

    select LAYER_STYLE_SHEET_ID, rowid
    from CSF_MD_LYR_STYLE_SHTS
    where LAYER_STYLE_SHEET_ID >= start_id
    order by LAYER_STYLE_SHEET_ID;

Line: 251

        delete from CSF_MD_LYR_STYLE_SHTS where rowid = r1.rowid;

Line: 271

    select name_id, rowid
    from csf_md_names
    where name_id >= start_id
    order by name_id;

Line: 296

        delete from csf_md_names where rowid = r1.rowid;

Line: 314

    select poi_id, rowid
    from csf_md_pois
    where poi_id >= start_id
    order by poi_id;

Line: 339

        delete from csf_md_pois where rowid = r1.rowid;

Line: 359

    select poi_nm_asgn_id, rowid
    from csf_md_poi_nm_asgns
    where poi_nm_asgn_id >= start_id
    order by poi_nm_asgn_id;

Line: 384

        delete from csf_md_poi_nm_asgns where rowid = r1.rowid;

Line: 404

    select railroad_segment_id, rowid
    from csf_md_rail_segs
    where railroad_segment_id >= start_id
    order by railroad_segment_id;

Line: 429

        delete from csf_md_rail_segs where rowid = r1.rowid;

Line: 449

    select rd_seg_nm_id, rowid
    from csf_md_rdseg_nm_asgns
    where rd_seg_nm_id >= start_id
    order by rd_seg_nm_id;

Line: 474

        delete from csf_md_rdseg_nm_asgns where rowid = r1.rowid;

Line: 494

    select road_segment_id, rowid
    from csf_md_rd_segs
    where road_segment_id >= start_id
    order by road_segment_id;

Line: 519

        delete from csf_md_rd_segs where rowid = r1.rowid;

Line: 539

    select theme_id, rowid
    from csf_md_theme_metadata
    where theme_id >= start_id
    order by theme_id;

Line: 564

        delete from csf_md_theme_metadata where rowid = r1.rowid;