UFN_RESERVATION_DEPOSITPASTDUE

            CREATE function dbo.UFN_RESERVATION_DEPOSITPASTDUE
            (
                @RESERVATIONID uniqueidentifier,
                @DATETOCHECK date
            )
            returns bit
            with execute as caller
            as begin

                declare @DEPOSITAMOUNT money;
                declare @DEPOSITDUEDATE date;
                declare @DEPOSITREQUIRED bit;

                select @DEPOSITAMOUNT = isnull(DEPOSITAMOUNT, 0),
                    @DEPOSITDUEDATE = DEPOSITDUEDATE,
                    @DEPOSITREQUIRED = DEPOSITREQUIRED
                from dbo.RESERVATION 
                where @RESERVATIONID = ID and 
                    DEPOSITREQUIRED = 1

                if @DEPOSITDUEDATE is not null and @DEPOSITDUEDATE < @DATETOCHECK and @DEPOSITREQUIRED = 1
                begin
                    if dbo.UFN_RESERVATION_ISDEPOSITPAID(@RESERVATIONID) = 0
                        return 1;
                end

                return 0;
            end