838: ,hlc.postal_code) postcode
839: ,hr_general.decode_lookup ('HR_NL_CITY'
840: ,hlc.town_or_city) city
841: ,hlc.country country
842: FROM hr_locations hlc
843: ,hr_organization_units hou
844: WHERE hou.business_group_id = p_business_group_id
845: AND hou.organization_id = l_tax_org_id
846: AND hlc.location_id = hou.location_id;