USP_FENXT_PROJECTIDFROMDESIGNATION

            create procedure dbo.USP_FENXT_PROJECTIDFROMDESIGNATION
                (
                @ID uniqueidentifier
                )
            as
                select top 1 
                    FENXTPROJECT.UIPROJECTID,
                    FENXTINTEGRATION.PDACCOUNTSYSTEMID
                from dbo.DESIGNATIONALTLOOKUPID
                    inner join dbo.FENXTPROJECT on DESIGNATIONALTLOOKUPID.ALTLOOKUPID = FENXTPROJECT.UIPROJECTID
                    inner join dbo.FENXTINTEGRATION on FENXTPROJECT.PDACCOUNTSYSTEMID = FENXTINTEGRATION.PDACCOUNTSYSTEMID
                where DESIGNATIONALTLOOKUPID.DESIGNATIONID = @ID 
                    and DESIGNATIONALTLOOKUPID.ALTLOOKUPIDTYPECODEID = 'E5837E89-B51A-4BAD-8E06-50D515DC64A2'
                order by
                    FENXTINTEGRATION.FEDESIGNATIONSOURCE desc,
                    DESIGNATIONALTLOOKUPID.DATEADDED;