City Name in City Taxes tax card not matching the backend value

Summary:

City Name in City Taxes tax card not matching the backend value

Content (required):

The requirement is to fetch the City Taxes Calculation Component from Tax Withholding calculation card of an employee.

As per Oracle document https://support.oracle.com/epmos/faces/DocumentDisplay?id=2727353.1 , State, County and City is stored in the Context Value 1,2 and 3 respectively in pay_dir_card_components_f table. To get the City Name we need to query the hz_geography_identifiers table with the combination of Context values with Identifier Value. But the issue is with the same combination we are getting multiple rows in the hz_geography_identifiers table each having different Geography IDs of type CITY.