UFN_SITEID_MAPFROM_GLTRANSACTIONID

             CREATE function dbo.UFN_SITEID_MAPFROM_GLTRANSACTIONID  
             (  
                @GLTRANSACTIONID uniqueidentifier  
             )   
             returns table
             as  
              return
                  (
                    select distinct SITES.SITEID
                    from dbo.JOURNALENTRY
                    cross apply dbo.UFN_SITEID_MAPFROM_REVENUESPLITID(JOURNALENTRY.FINANCIALTRANSACTIONLINEITEMID) SITES
                    where JOURNALENTRY.ID = @GLTRANSACTIONID
                  )