spFundraiserGetREGiftIDs

            CREATE PROCEDURE dbo.spFundraiserGetREGiftIDs
            (@FRID int)
            AS
            BEGIN
                SELECT frd.GiftBackOfficeID
                FROM dbo.FundraiserDonations frd
                INNER JOIN dbo.DonationTransactions dt on frd.DonationTransactionsID = dt.DonationTransactionsID and dt.IsDeleted = 0 and dt.Status = 1
                INNER JOIN dbo.FundraiserSolicitors frs on frd.SolicitorID = frs.ID and frs.RootFundraiserID = @FRID
                WHERE not frd.GiftBackofficeID is NULL
            END