In rhis sproc:

usingtt.usp_CompanyCheckoffStatsGet

I have:

    UPDATE m SET m.RegularDuesOwing =
    ISNULL((SELECT SUM(mfa.RegularDues) FROM #UnpaidMonths um JOIN MonthlyFixedAmount mfa ON mfa.ChargeMonth = um.MonthUnpaid WHERE um.MemberId = c.MemberId), 0)
    FROM #Member m
    JOIN Contact c (NOLOCK) ON c.MemberId = m.MemberID
    JOIN Standing ss ON c.StandingId = ss.StandingId
    WHERE ss.Active = 1

MonthlyFixedAmount.RegularDues (in dbo) no longer exists but Find Invalid Objects did not pick up usingtt.usp_CompanyCheckoffStatsGet