When declining a new registration (registration approval on), just the users entry in the USERS table gets deleted. The whole profile in USER_PROFILE and the groups in USER_GROUPS are kept (and maybe even more, didn't check that).
As a side effect, the declined email address now gets rejected on every new registration, because it's already occupied.