UFN_SITEID_MAPFROM_MISCELLANEOUSPAYMENTID

      CREATE function dbo.UFN_SITEID_MAPFROM_MISCELLANEOUSPAYMENTID  
      (  
        @PAYMENTID uniqueidentifier  
      )   
      returns table
      as  
      return
      (          
        select distinct 
          S.SITEID
        from 
          dbo.FINANCIALTRANSACTION FT
          inner join dbo.FINANCIALTRANSACTIONLINEITEM FTLI on FTLI.FINANCIALTRANSACTIONID = FT.ID
          inner join dbo.REVENUESPLIT_EXT EXT on EXT.ID = FTLI.ID
          left join dbo.PDACCOUNTSYSTEMSITE S on S.PDACCOUNTSYSTEMID = FT.PDACCOUNTSYSTEMID
        where 
          EXT.APPLICATIONCODE = 11 
          and EXT.TYPECODE = 8
          and FT.ID = @PAYMENTID
      )