City Name mismatch in frontend and backend for city taxes

Summary:

Hello,

I am trying to get the city value for which the tax is being processed. The city value in the frontend page does not match the value returned by the SQL. The issue is because one identifier value is associated with multiple cities. This is the case with many identifier values. The SQL i am using is :

SELECT geo.geography_name
FROM hz_geography_identifiers geo_ident , hz_geographies geo
where geo_ident.geography_id = geo.geography_id
AND geo_ident.identifier_subtype = 'GEO_CODE'
AND geo_ident.geography_type  = 'CITY'
AND geo.geography_type  = 'CITY'
AND geo_ident.identifier_value = (prr.area_code1 || '-' || prr.area_code2 || '-' || prr.area_code3 )