APPS.HZ_GEOGRAPHY_STRUCTURE_PUB dependencies on HZ_GEO_NAME_REFERENCES

Line 806: FROM hz_geo_name_references

802: AND country_code = l_country_code;
803:
804: CURSOR c_get_geo_name_ref is
805: SELECT location_id,Location_table_name
806: FROM hz_geo_name_references
807: WHERE geography_id = l_geography_id;
808:
809: CURSOR c_get_ranges is
810: SELECT geography_id,master_ref_geography_id,geography_from,

Line 1056: delete hz_geo_name_references

1052: loop
1053: fetch c_get_geo_name_ref into l_location_id,l_loc_tbl_name;
1054: exit when c_get_geo_name_ref%NOTFOUND;
1055:
1056: delete hz_geo_name_references
1057: where location_id = l_location_id
1058: and location_table_name = l_loc_tbl_name;
1059:
1060: delete hz_geo_name_reference_log