USP_GET_EVENTAPPEAL_BY_FINDERNUMBER

        CREATE procedure dbo.USP_GET_EVENTAPPEAL_BY_FINDERNUMBER
        ( @FINDERNUMBER bigint)
        as
        begin
            declare @APPEALID uniqueidentifier;
            select top 1 @APPEALID = [APPEALID] from dbo.[CONSTITUENTAPPEAL] where [FINDERNUMBER] = @FINDERNUMBER;
            select ID from dbo.BBNCAPPEALIDMAP where APPEALID =@APPEALID
        end