Блокировка процесса?

ALTER PROCEDURE [dbo].[sp_CreateDebtor]
(@ContractID uniqueidentifier)
AS
BEGIN
	SET NOCOUNT ON;
 
	declare @DelayDebt decimal(15,4)
	declare @AllDebt decimal(15,4)
	declare @CurrentDebt decimal(15,4)
	set @DelayDebt = (select [dbo].[f_getDebtorDolg](@ContractID,3))
	set @AllDebt = (select [dbo].[f_getDebtorDolg](@ContractID,2))
	set @CurrentDebt =  (select [dbo].[f_getDebtorDolg](@ContractID,1))	
 
	if (not EXISTS(select ContractID from tbl_Debtor db where db.ContractID = @ContractID))
		or (EXISTS(select ContractID 
			from tbl_Debtor db1 
			left join
			tbl_DebtorState as ds on ds.ID = db1.StateID
			where db1.ContractID = @ContractID
			and ds.Code = 'Close' 
			and db1.DebtDate = (select MAX(ISNULL(DebtDate,GETDATE())) from tbl_Debtor db3 
									where @ContractID = db3.ContractID)))
	begin
 
		if not EXISTS(select 
		SUM(ISNULL(i.PaymentAmount,0)) - SUM(ISNULL(i.Amount,0))
		from tbl_Invoice i
		left join 
		tbl_Contract as c on c.ID = i.ContractID
		where not ContractID is null
		and c.ContractTypeID = 'ED7FD7B2-46A7-4583-8FB4-37356272EB8A'
		and contractID	= @ContractID
		group by ContractID
		HAVING SUM(ISNULL(i.PaymentAmount,0)) - SUM(ISNULL(i.Amount,0)) < 0 )
		begin
			return
		end
 
		insert into tbl_Debtor
		(ID,CreatedOn,ContractID,DebtDate,AccountID,DebtorNumber,StateID,ActionID,
		DelayDebt, AllDebt, CurrentDebt,IsOff)
		Values(
			newID(),
			GETDATE(), 
			@ContractID,
			GETDATE()
			,(select CustomerID from tbl_Contract where ID = @ContractID)
			,Cast(Month(GetDate())as varchar(5))+substring(Cast(YEAR(GetDate())as varchar(5)),3,5)+
			 (select ContractNumber from tbl_Contract where ID = @ContractID)
			,(select ID from tbl_DebtorState where Code = 'New')
			,(select ID from tbl_DebtorAction where IsStart = 1)
			,@DelayDebt
			,@AllDebt
			,@CurrentDebt
			,0)
			-----exec [dbo].[sp_SetAccessDebtor] @ContractID
	end
	else	
		begin
			update tbl_Debtor
				set CurrentDebt = @CurrentDebt, 
					AllDebt = @AllDebt,
					DelayDebt = @DelayDebt
 
			where tbl_Debtor.ContractID = @ContractID
				  and 
			tbl_Debtor.DebtDate = (select MAX(ISNULL(db3.DebtDate,GETDATE())) from tbl_Debtor db3 
									where @ContractID = db3.ContractID)	
 
		end
 
 
END

Create PROCEDURE [dbo].[sp_CreateDebtor]
(@ContractID uniqueidentifier)
AS
BEGIN
        SET NOCOUNT ON;
 
        declare @DelayDebt decimal(15,4)
        declare @AllDebt decimal(15,4)
        declare @CurrentDebt decimal(15,4)
 
        begin
 
                IF NOT EXISTS(SELECT
                SUM(ISNULL(i.PaymentAmount,0)) - SUM(ISNULL(i.Amount,0))
                FROM tbl_Invoice i
                LEFT JOIN
                tbl_Contract AS c ON c.ID = i.ContractID
                WHERE NOT ContractID IS NULL
                AND c.ContractTypeID = 'ED7FD7B2-46A7-4583-8FB4-37356272EB8A'
                AND contractID  = @ContractID
                GROUP BY ContractID
                HAVING SUM(ISNULL(i.PaymentAmount,0)) - SUM(ISNULL(i.Amount,0)) < 0 )
                begin
                        RETURN
                end
 
 
		end	              
END

WAITFOR DELAY '00:00:10'