MySQL return rows ONLY if ALL the rows in another table have a specified value
Turn it around and do something like
WHERE NOT EXISTS ( SELECT 1 FROM cms.cms_efd_status
                   WHERE ... != ... )
  AND e.earnings_file_id = 400676