Tax Employee Card/ Economic Zone

I'm trying to pull the Economic Zones for Mexico, but it seems that the query I'm using is only returning one single value as "A" where other values should be found as well (e.g 'Zone B (Source: TRU-CD JUAREZ CHI Reg Pat AZ').

select

cd.name,

ao.prompt,

ri.value1,

ri.legislation_code,

ri.legislative_data_group_id

from

pay_allow_overrides_vl ao,

pay_value_defnitions_vl vd,

pay_range_items_f ri

where 1=1

and ri.value_Defn_id = vd.value_Defn_id

and vd.legislation_code = ´MX'

source_id is showing empty for Mexico employees, so there's no way to use a join for this field.