UFN_FUNDINGREQUEST_GETAMOUNTAWARDEDINCURRENCY

Returns the amount awarded for the given funding request in the given currency.

Return

Return Type
money

Parameters

Parameter	Parameter Type	Mode	Description
@FUNDINGREQUESTID	uniqueidentifier	IN
@CURRENCYID	uniqueidentifier	IN

Definition

Copy



create function dbo.UFN_FUNDINGREQUEST_GETAMOUNTAWARDEDINCURRENCY(
  @FUNDINGREQUESTID uniqueidentifier,
  @CURRENCYID uniqueidentifier
)
returns money
with execute as caller
as begin

  declare @GRANTAWARDAMOUNT money = 0;            
  declare @WRITEOFFAMOUNT money = 0;

  select 
      @GRANTAWARDAMOUNT = sum(dbo.UFN_REVENUE_GETAMOUNTINCURRENCY(REVENUE.ID , @CURRENCYID))                
  from 
      dbo.REVENUE
      inner join dbo.REVENUEFUNDINGREQUEST on REVENUE.ID = REVENUEFUNDINGREQUEST.ID
  where 
      REVENUEFUNDINGREQUEST.FUNDINGREQUESTID = @FUNDINGREQUESTID;

  select 
      @WRITEOFFAMOUNT = isnull(sum(dbo.UFN_INSTALLMENTSPLITWRITEOFF_GETAMOUNTINCURRENCY(REVENUE.ID ,@CURRENCYID)), 0)

  from 
      dbo.INSTALLMENTSPLITWRITEOFF 
      inner join dbo.INSTALLMENTSPLIT on INSTALLMENTSPLITWRITEOFF.INSTALLMENTSPLITID = INSTALLMENTSPLIT.ID 
      inner join dbo.REVENUE on INSTALLMENTSPLIT.PLEDGEID = REVENUE.ID
      inner join dbo.REVENUEFUNDINGREQUEST on REVENUE.ID = REVENUEFUNDINGREQUEST.ID
  where 
      REVENUEFUNDINGREQUEST.FUNDINGREQUESTID = @FUNDINGREQUESTID;

    return isnull((@GRANTAWARDAMOUNT - @WRITEOFFAMOUNT),0)
end