select newid() as Id, 'T' as acConfrm from vHE_PayOrder P join tHR_LinkTrvlPayOrder V on P.acKey = V.acLnkKey  where (V.acType = 'VV' or V.acType = 'VA' or V.acType = 'VI' or V.acType = 'AV') and V.acKey = @acKey