UFN_CONSTITID_MAPFROM_REVENUETRANSACTIONID

CREATE function dbo.UFN_CONSTITID_MAPFROM_REVENUETRANSACTIONID(@REVENUEID uniqueidentifier) 
returns uniqueidentifier
as
begin

    DECLARE @ID uniqueidentifier;

    select top 1 @ID=CONSTITUENTID 
  from 
      dbo.FINANCIALTRANSACTION 
      inner join dbo.REVENUE_EXT on FINANCIALTRANSACTION.ID = REVENUE_EXT.ID
  where 
      FINANCIALTRANSACTION.ID = @REVENUEID 
      and FINANCIALTRANSACTION.TYPECODE in (0,1,2,3,4,5,6,7,8,9) 
      and FINANCIALTRANSACTION.DELETEDON is null;

    RETURN @ID;

end