What will happen to my investment losses once I die?

In the eyes of the taxman, capital losses have a limited life. But things can change if you have a self-managed super fund.