spGetFundraiserSolicitorAndPageID

            CREATE   PROCEDURE [dbo].[spGetFundraiserSolicitorAndPageID]
            @BackOfficeID int,
            @FundraiserID int

            as

            SELECT frp.SitePageID, frs.[ID] as SolicitorID 
            FROM FundraiserSolicitors as frs 
            inner join FundraiserPages as frp on frp.[ID] = dbo.fnFundRaiserPageID(frs.ID, 1)
            inner join vwBackOfficeLinkedUsers as vbolu on frs.ClientUsersID = vbolu.UserID
            WHERE vbolu.BackofficeRecordID = @BackOfficeID AND frs.RootFundraiserID = @FundraiserID