SELECT ebm.EMPID_I as Employee_Id, 
MAX(Case when left(med.benefit,2) = ('14') then med.COSTEMPLOYEE_I else 0 end) as Medical_Amount,
MAX(Case when left(den.benefit,2) = ('15') then med.COSTEMPLOYEE_I else 0 end) as Dental_Amount
FROM BE010130 ebm (nolock)
inner join BE010130 med (nolock) on ebm.EMPID_I = med.EMPID_I and ebm.BENEFIT = med.BENEFIT
WHERE ebm.BENEFITSTATUS_I = 1 -- Active Only
and ebm.BENEFIT in (select BENEFIT from BE020230 ben (nolock) where (ben.DSCRIPTN LIKE 'D/ UHC%' or ben.DSCRIPTN LIKE 'D/ Dental%'))
and ebm.empid_i = 1331
Group by ebm.EMPID_I