UFN_MERCHANTACCOUNT_GETBYEVENTIDORLOCALCORPID

create function dbo.UFN_MERCHANTACCOUNT_GETBYEVENTIDORLOCALCORPID
(
  @EVENTID uniqueidentifier = null,
  @LOCALCORPID uniqueidentifier = null
)
returns uniqueidentifier
with execute as caller
as begin
  declare @MERCHANTACCOUNT uniqueidentifier;

  if @LOCALCORPID is not null
      select top 1 @MERCHANTACCOUNT = M.ID 
      from dbo.MERCHANTACCOUNT M(nolock)
      inner join dbo.LOCALCORP L(nolock) on L.BBPSMERCHANTACCTID = M.ID
      where L.ID = @LOCALCORPID;

  if @MERCHANTACCOUNT is null 
    if @EVENTID is not null
      select top 1 @MERCHANTACCOUNT = M.ID 
      from dbo.MERCHANTACCOUNT M(nolock)
      inner join dbo.EVENTEXTENSION E(nolock) on E.MERCHANTACCOUNTID = M.ID
      where E.EVENTID = @EVENTID;

  return @MERCHANTACCOUNT;
end