UFN_SITEID_MAPFROM_BANKACCOUNTADJUSTMENTID

             CREATE function dbo.UFN_SITEID_MAPFROM_BANKACCOUNTADJUSTMENTID  
             (  
                @BANKACCOUNTADJUSTMENTID uniqueidentifier  
             )   
             returns table
             as  
            return
                (
                    select distinct CONSTITUENTSITE.SITEID
                    from dbo.BANKACCOUNTADJUSTMENT
          inner join dbo.FINANCIALTRANSACTION FT on BANKACCOUNTADJUSTMENT.ID = FT.ID
          inner join dbo.BANKACCOUNTTRANSACTION_EXT BATX on BATX.ID = FT.ID
          inner join dbo.BANKACCOUNT on BANKACCOUNT.ID = BATX.BANKACCOUNTID
          inner join dbo.BANK on BANK.ID = BANKACCOUNT.BANKID
          left outer join dbo.CONSTITUENTSITE on BANK.ID = CONSTITUENTSITE.CONSTITUENTID 
                    where BANKACCOUNTADJUSTMENT.ID = @BANKACCOUNTADJUSTMENTID
                )