DECLARE @acmastid VARCHAR(40)
DECLARE @INTRATE NUMERIC(18,2)
DECLARE @PINTRATE NUMERIC(18,2)

DECLARE H1 CURSOR FOR
SELECT acmastid,intrate,pintrate FROM loanviewall 
OPEN h1
FETCH NEXT FROM h1 INTO @acmastid,@INTRATE,@PINTRATE
WHILE @@FETCH_STATUS = 0
BEGIN
	UPDATE INTTRAN SET INTRATE = @INTRATE WHERE ElementID ='#INT-NORMAL' AND ACMASTID = @ACMASTID AND FACTACMASTID =@ACMASTID
	UPDATE INTTRAN SET INTRATE = @PINTRATE WHERE ElementID ='#INT-PENAL' AND ACMASTID = @ACMASTID AND FACTACMASTID =@ACMASTID
	FETCH NEXT FROM h1 INTO @acmastid,@INTRATE,@PINTRATE
END
DEALLOCATE h1