***no of a/c diff
update AcMast set r = 2,T = 1  , EDT = GETDATE()  where  AcMastId in ( select AcMastId  from acsub where AcMastId  not in (select distinct acsubid from voucher where AcSubId is not null  and r = 0 and t = 0)  and type = 3 and AcSuperId ='#ACMASLOANSASSET')
update AcMast set r = 2,T = 1  , EDT = GETDATE()  where  AcMastId in ( select AcMastId  from acsub where AcMastId  not in (select distinct acsubid from voucher where AcSubId is not null  and r = 0 and t = 0)  and type = 3 and AcSuperId ='#ACMASDEPOSITLIABILITIES')