USP_REVENUE_GETBASICDETAILS

      CREATE procedure [dbo].[USP_REVENUE_GETBASICDETAILS] 
                (
                    @REVENUEID uniqueidentifier
                )
                as 
                begin
          select
              R.ID,
              R.CONSTITUENTID,
              (
                  select
                      dbo.UDA_BUILDLIST(distinct RR.CONSTITUENTID)
                  from
                       dbo.REVENUERECOGNITION RR
                       inner join dbo.REVENUESPLIT RS
                          ON RR.REVENUESPLITID = RS.ID and RS.REVENUEID = @REVENUEID 
              ) as 'REVENUERECOGNITIONIDS',
              R.TRANSACTIONAMOUNT,
              R.[DATE],
              [dbo].[UFN_PLEDGE_GETBALANCE](R.[ID]) as 'BALANCE',
              R.[DESCRIPTION],
              R.TRANSACTIONTYPECODE,
              R.TRANSACTIONCURRENCYID
          from
              dbo.REVENUE R
          where
              R.ID = @REVENUEID
        end