UFN_PLEDGE_GETPASTDUEAMOUNT

CREATE function dbo.UFN_PLEDGE_GETPASTDUEAMOUNT
(
  @PLEDGEID uniqueidentifier
)
returns money
with execute as caller
as
begin
  declare @RESULT money;
  declare @DUEDATE datetime;

  set @DUEDATE = dbo.UFN_DATE_GETEARLIESTTIME(GetDate());

  select @RESULT = 
    isnull(
      (select
         sum(dbo.UFN_INSTALLMENT_GETINSTALLMENTBALANCE(INSTALLMENT.ID))
       from dbo.INSTALLMENT
       where INSTALLMENT.REVENUEID = @PLEDGEID 
       --The "GETLATESTTIME" date function has been inlined here for performance (the part with "dateadd(ms, -003...")...

       and dateadd(ms, -003, dateadd(d, 1, cast(cast(INSTALLMENT.DATE as date) as datetime))) < @DUEDATE),
      0);

  return @RESULT;
end