USP_DATALIST_FAFGroupMemberOnDonationReceived

CREATE procedure dbo.USP_DATALIST_FAFGroupMemberOnDonationReceived(
       @EVENTID         uniqueidentifier,    
       @CONSTITUENTID   uniqueidentifier,
       @CLIENTUSERID    int
 )
as
    set nocount on;

  DECLARE @MYADDRESSBOOK table (    
             GROUPNAME        nvarchar(100),    
             CATEGORYSTATUS   nvarchar(100),    
             ADDRESSBOOKID    uniqueidentifier null,    
             NAME             varchar(200) null,    
             CONSTITUENTID    uniqueidentifier null,    
             EMAILADDRESS     varchar(200) null,    
             REGISTRANTID     uniqueidentifier null,
             ALLOWOTHERPARTICIPANTSCONTACTME bit  default(1)
      ) 

 Insert Into @MYADDRESSBOOK Exec USP_FAFADDRESSBOOK_GETALLGROUPMEMBERS @TYPE='Current', @EVENTID = @EVENTID, @CONSTITUENTID = @CONSTITUENTID

 Select af.CONSTITUENTID, af.ID As AddressbookID, c.FIRSTNAME, c.KEYNAME As LastName, 
      af.EMAILADDRESS, rr.AMOUNT As donationamount 
      from @MYADDRESSBOOK  ab 
        Inner join REVENUERECOGNITION rr on rr.CONSTITUENTID = ab.CONSTITUENTID
        Inner Join ADDRESSBOOKFAF af on ab.CONSTITUENTID = af.CONSTITUENTID
        Inner Join CONSTITUENT c on c.ID = ab.CONSTITUENTID
      where af.CLIENTUSERSID in (select CLIENTUSERID from dbo.UFN_CLIENTUSERS_GETIDLISTBYCONSTITUENTID(@CONSTITUENTID)) and af.CONSTITUENTID <> @CONSTITUENTID
        and rr.AMOUNT > 0 and af.emailaddress <> ''