1165: g_state ,
1166: g_county ,
1167: g_country ,
1168: g_postal_code
1169: FROM hr_organization_units hou,
1170: hr_locations hl
1171: WHERE hou.location_id = hl.location_id
1172: AND hou.organization_id = g_legal_company_id
1173: and p_effective_date between hou.date_from and nvl(hou.date_to,p_effective_date);