EA7_spGetFundraiserSolicitorAndPageID

            CREATE   PROCEDURE [dbo].[EA7_spGetFundraiserSolicitorAndPageID]
            @BackOfficeRecordsID int,
            @FundraiserID int
            AS
            begin
            set nocount on
            DECLARE @returnAll bit
            SET @returnAll = 0        -- default return the chosen personal page for Directory(EE) part

            IF @FundraiserID < 0    
                        SET @returnAll = 1    -- return all personal pages for FAWeb / NetClassroom

                    SELECT frp.SitePageID, frs.[ID] 'SolicitorID', upp.Name 'PageName'
                    FROM dbo.FundraiserSolicitors as frs 
                    inner join dbo.UserPersonalPages upp on upp.ParentID=frs.ID 
                    inner join dbo.FundraiserPages as frp on frp.[ID] = dbo.fnFundRaiserPageID(frs.ID, 1)
                    inner join dbo.vwBackOfficeLinkedUsers as vbolu on frs.ClientUsersID = vbolu.UserID
                    WHERE vbolu.BackOfficeSystemID = 1 and vbolu.BackofficeRecordID = @BackOfficeRecordsID AND (@returnAll = 1 or frs.FundraiserID = @FundraiserID)
                end