UFN_SITEID_MAPFROM_DESIGNATIONLEVELDISBURSEMENTID

        create function dbo.UFN_SITEID_MAPFROM_DESIGNATIONLEVELDISBURSEMENTID
        (
            @DESIGNATIONLEVELDISBURSEMENTID uniqueidentifier
        )
        returns uniqueidentifier
        as
        begin

            declare @ID uniqueidentifier

            select
                @ID = DESIGNATIONLEVEL.SITEID
            from dbo.DESIGNATIONLEVELDISBURSEMENT
            inner join dbo.DESIGNATIONLEVEL on DESIGNATIONLEVELDISBURSEMENT.DESIGNATIONLEVELID = DESIGNATIONLEVEL.ID
            where DESIGNATIONLEVELDISBURSEMENT.ID = @DESIGNATIONLEVELDISBURSEMENTID

            return @ID
        end