DECLARE @BillMastId VARCHAR(40)
DECLARE @AcParentId VARCHAR(40)
DECLARE @AcMastId VARCHAR(40)
DECLARE @IssueDt DATETIME
DECLARE h1 CURSOR FOR 
SELECT BillOp.BillMastId, LoanViewAll.AcParentId,LoanViewAll.AcMastId ,BillOp.IssueDt
FROM LoanViewAll INNER JOIN
BillOp ON LoanViewAll.AcMastId = BillOp.AcSubId AND BillOp.R = 0
INNER JOIN BILLMAST ON BILLOP.BILLMASTID = BILLMAST.BILLMASTID
WHERE BILLMAST.DT ='2014/03/31'
OPEN H1
FETCH NEXT FROM h1 INTO @BillMastId,@AcParentId,@AcMastId,@IssueDt
WHILE @@FETCH_STATUS = 0
BEGIN
	update VoLoanDet set EffectDt = @IssueDt WHERE BillMastID =@BillMastId AND
	AcMastID = @AcParentId AND AcSubId = @AcMastId AND DR > 0 AND ElementID = '#PRINCIPLE'
	FETCH NEXT FROM h1 INTO @BillMastId,@AcParentId,@AcMastId,@IssueDt
END
DEALLOCATE h1