APPS.HZ_GEOGRAPHY_STRUCTURE_PUB dependencies on HZ_GEOGRAPHY_IDENTIFIERS

Line 1047: delete hz_geography_identifiers

1043: delete hz_geographies
1044: where geography_id = l_geography_id;
1045:
1046: -- Delete geography identifiers
1047: delete hz_geography_identifiers
1048: where geography_id = l_geography_id;
1049:
1050: -- delete geo name reference and geo name ref log
1051: open c_get_geo_name_ref;

Line 1140: DELETE hz_geography_identifiers

1136: AND geography_use = 'TAX';
1137:
1138: -- delete identifiers and relationships for tax zones to be deleted
1139:
1140: DELETE hz_geography_identifiers
1141: WHERE geography_id IN (SELECT geography_id
1142: FROM hz_geographies
1143: WHERE geography_type = l_zone_type
1144: AND geography_use = 'TAX');