There are 8 types of citta rooted in lobha (greed) 4 are ditthigata sampayutta (associated with wrong view )and 4 are not. The sotapanna and sakadagami can still enjoy sex and have greed for all manner of sense objects. But the 4 consciousness associated with wrong view can never arise for them.
http://www.zencomp.com/greatwisdom/ebud/abhisgho/abhis01.htm1. Somanassa-sahagatam, ditthigatasampayuttam, asankharikam ekam
One consciousness, unprompted, accompanied by pleasure, connected with wrong view
2. Somanassa-sahagatam, ditthigatasampayuttam, sasankharikam ekam,
One consciousness, prompted, accompanied by pleasure, connected with wrong view
3. Somanassa-sahagatam ditthigatavippayuttam, asankharikam ekam
One consciousness, unprompted, accompanied by pleasure, disconnected with wrong view
4. Somanassa-sahagatam ditthigatavippayuttam, sasankharikam ekam
One consciousness, prompted, accompanied by pleasure, disconnected with wrong view
5. Upekkha-sahagatam, ditthigatasampayuttam, asankharikam ekam
One consciousness, unprompted, accompanied by indifference, connected with wrong view
6. Upekkha-sahagatam, ditthigatasampayuttam, sasankharikam ekam
One consciousness, prompted, accompanied by indifference, connected with wrong view
7. Upekkha-sahagatam, ditthigatavippayuttam, asankharikam ekam
One consciousness, unprompted, accompanied by indifference, disconnected with wrong view
8. Upekkha-sahagatam, ditthigatavippayuttam, sasankharikam ekan' ti
One consciousness, prompted, accompanied by indifference, disconnected with wrong view
Imani attha'pi Lobhasahagatacittani nama
These eight types of consciousness are rooted in Attachment