How to link tax_jurisdiction_id with location?

Hi,

I am trying to generate location tax for a sales order. But for generating the tax, i need the tax_jurisdiction_id for that particular location.

Either i need a connection between the shipping_location and the tax jurisdiction

OR

i need to retrieve the relationship_id from the hz_relationships table so that i can get the subject_id for the corresponding object_id.

Given below are the sample queries i was working on. Here i found out the tax_jurisdiction_id using forms builder and hence hardcoded it.

select * from hz_geographies

where country_code = 'US' and geography_type = 'STATE'