Query taking access amount of time

Hello,  This query is taking too long (days and days). Tables have only 2GB data all together.  Please see explain plan below.  Thanks for any help.

INSERT INTO temp_memlang
SELECT DISTINCT m.member_nbr,
        c.language_x
FROM    member m
        INNER JOIN member_span s
        ON      m.member_nbr  = s.member_nbr
                AND s.void    = ' '
                AND s.ymdend IN
                (
                        SELECT  MAX(ms2.ymdend)
                        FROM    member_span ms2
                        WHERE   ms2.member_nbr = s.member_nbr
                                AND ms2.void   = ' '
                        GROUP BY ms2.member_nbr,
                                ms2.ymdeff     ,
                                ms2.ymdend
                        HAVING COUNT(ms2.member_nbr)=1
                )
                INNER JOIN contract c