UFN_REVENUEBATCH_GETBENEFITSFORPAYMENTPLEDGE

Retrieves all of the benefits for a pledge added during the revenue batch process.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@BATCHREVENUEAPPLICATIONPLEDGEID	uniqueidentifier	IN

Definition

Copy



      CREATE function dbo.UFN_REVENUEBATCH_GETBENEFITSFORPAYMENTPLEDGE
      (
          @BATCHREVENUEAPPLICATIONPLEDGEID uniqueidentifier
      )
      returns table
      as return
      (
          select
              ID,
              BENEFITID,
              QUANTITY,
              UNITVALUE,
              DETAILS,
              SEQUENCE,
              BENEFITCURRENCYID
          from BATCHREVENUEAPPLICATIONPLEDGEBENEFIT
          where BATCHREVENUEAPPLICATIONPLEDGEID = @BATCHREVENUEAPPLICATIONPLEDGEID
      )