UFN_SITEID_MAPFROM_DESIGNATIONLEVELFINANCIALINFOID

        create function dbo.UFN_SITEID_MAPFROM_DESIGNATIONLEVELFINANCIALINFOID(@DESIGNATIONLEVELFINANCIALINFOID uniqueidentifier) 
        returns uniqueidentifier
        as
        begin

            DECLARE @ID uniqueidentifier;

            SELECT @ID=DESIGNATIONLEVEL.SITEID from dbo.DESIGNATIONLEVELFINANCIALINFO
            inner join dbo.DESIGNATIONLEVEL on DESIGNATIONLEVELFINANCIALINFO.DESIGNATIONLEVELID = DESIGNATIONLEVEL.ID
            where DESIGNATIONLEVELFINANCIALINFO.ID=@DESIGNATIONLEVELFINANCIALINFOID;

            RETURN @ID;

        end