Yes, you have to cancel your family member’s visas under your sponsorship prior to cancel your RP. It is mandatory by immigration dept.

Your employer also will ask for it.