UFN_SITEID_MAPFROM_DESIGNATIONLEVELDECAPITALIZATIONID

        create function dbo.UFN_SITEID_MAPFROM_DESIGNATIONLEVELDECAPITALIZATIONID(@DESIGNATIONLEVELDECAPITALIZATIONID uniqueidentifier) 
        returns uniqueidentifier
        as
        begin

            DECLARE @ID uniqueidentifier;

            SELECT @ID=DESIGNATIONLEVEL.SITEID from dbo.DESIGNATIONLEVELDECAPITALIZATION
            inner join dbo.DESIGNATIONLEVEL on DESIGNATIONLEVELDECAPITALIZATION.DESIGNATIONLEVELID = DESIGNATIONLEVEL.ID
            where DESIGNATIONLEVELDECAPITALIZATION.ID=@DESIGNATIONLEVELDECAPITALIZATIONID;

            RETURN @ID;

        end