UFN_RESERVATION_FINALPAYMENTPASTDUE

CREATE function dbo.UFN_RESERVATION_FINALPAYMENTPASTDUE
(
    @RESERVATIONID uniqueidentifier,
    @DATETOCHECK date
)
returns bit
with execute as caller
as begin
        declare @FINALPAYMENTDUEDATE date;
        declare @DEPOSIT money;
        declare @AMOUNTDUE money;

        select @FINALPAYMENTDUEDATE = FINALDUEDATE,
            @DEPOSIT = case DEPOSITREQUIRED when 1 then DEPOSITAMOUNT else 0 end
        from dbo.RESERVATION
        where RESERVATION.ID = @RESERVATIONID

        set @AMOUNTDUE = isnull(dbo.UFN_SALESORDER_GETAMOUNTDUE(@RESERVATIONID), 0)

        if ((@AMOUNTDUE > 0 or (@DEPOSIT >= @AMOUNTDUE and @DEPOSIT > 0)) and @FINALPAYMENTDUEDATE < @DATETOCHECK)
            return 1;

        return 0;
end