The curse on Kashyapa!

Kashyapa and Diti are blessed with immense power by Lord Vishnu. But Kashyapa's greed leads to a terrible curse from Lord Brahma. What is his fate?