UFN_MERCHANTACCOUNT_GETREGISTRANTMERCHANTACCOUNT

create function dbo.UFN_MERCHANTACCOUNT_GETREGISTRANTMERCHANTACCOUNT
(
  @LOCALCORPID uniqueidentifier = null,
  @EVENTID 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
    set @MERCHANTACCOUNT = dbo.UFN_MERCHANTACCOUNT_GETEVENTMERCHANTACCOUNT(@EVENTID);

  return @MERCHANTACCOUNT;
end