zOs/SQL/CMNALA

select *
    from SSXX28Q0.CMN_PARMS_C2100821
    where lat_urid in (
    select lat_urid
    from SSXX28Q0.CMN_PARMS_C2100821
    where parm_class = 'ALLOWERO'
      and parm_Key = '*'
      and parm_value = 'Y'
    )
    order by lat_lrsn desc