UFN_MERCHANTACCOUNT_GETEVENTMERCHANTACCOUNT

CREATE function dbo.UFN_MERCHANTACCOUNT_GETEVENTMERCHANTACCOUNT
(
  @EVENTID uniqueidentifier = null
)
returns uniqueidentifier
with execute as caller
as begin
  declare @MERCHANTACCOUNT uniqueidentifier;

  if @EVENTID is not null
      select @MERCHANTACCOUNT = MERCHANTACCOUNTID 
      from dbo.EVENTEXTENSION (nolock)
      where EVENTID = @EVENTID;

  if @MERCHANTACCOUNT is null
    set @MERCHANTACCOUNT = dbo.UFN_MERCHANTACCOUNT_GETDEFAULTAUTHORIZATIONACCOUNT();

  --if @MERCHANTACCOUNT is null

  --  select top 1 @MERCHANTACCOUNT = M.ID from dbo.MERCHANTACCOUNT M(nolock);


  return @MERCHANTACCOUNT;
end