UFN_ASSIGNLETTERCODESPROCESS_GETLETTERCODES

            create function dbo.UFN_ASSIGNLETTERCODESPROCESS_GETLETTERCODES
            (
                @ASSIGNLETTERCODESPROCESSID uniqueidentifier
            )
            returns table
            as
            return 
            (
                select
                    CODES.ID,
                    CODES.LETTERCODEID,
                    CODES.SEQUENCE
                from
                    dbo.ASSIGNLETTERCODESPROCESSLETTERCODES CODES
                inner join
                    dbo.LETTERCODE on CODES.LETTERCODEID = LETTERCODE.ID
                where
                    ASSIGNLETTERCODESPROCESSID = @ASSIGNLETTERCODESPROCESSID
                    and LETTERCODE.ISACTIVE = 1
                    and LETTERCODE.IDSETREGISTERID is not null
            )