UFN_SITEID_MAPFROM_DEPOSITID

             CREATE function dbo.UFN_SITEID_MAPFROM_DEPOSITID  
             (  
            @DEPOSITID uniqueidentifier  
             )   
             returns table
             as  
            return
                (
                    select distinct CONSTITUENTSITE.SITEID
                    from dbo.BANKACCOUNTDEPOSIT
          inner join dbo.BANKACCOUNTTRANSACTION_EXT BATX on BATX.ID = BANKACCOUNTDEPOSIT.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 BANKACCOUNTDEPOSIT.ID = @DEPOSITID
                )