Hare Krsna,
In the material world there is an attraction between woman and man. This is the arrangement of conditional life. A man and a woman attract each other, and in that way the scope of material activities, involving house, wealth, children and friendship, increases, and thus instead of decreasing one’s material demands, one becomes entangled in material enjoyment. This attraction between opposite genders is the dominance of the mode of passion.
“The grossest type of anartha which binds the conditioned soul in material existence is sex desire, and this sex desire gradually develops in the union of the male and female. When the male and female are united, the sex desire is further aggravated by the accumulation of buildings, children, friends, relatives and wealth. When all these are acquired, the conditioned soul becomes overwhelmed by such entanglements, and the false sense of egoism, or the sense of “myself” and “mine,” becomes prominent, and the sex desire expands to various political, social, altruistic, philanthropic and many other unwanted engagements, resembling the foam of the sea waves, which becomes very prominent at one time and at the next moment vanishes as quickly as a cloud in the sky.” (SB 2.2.12 Purport)
“The mode of passion is characterized by the attraction between man and woman. Woman has attraction for man, and man has attraction for woman. This is called the mode of passion. And when the mode of passion is increased, one develops the hankering for material enjoyment. He wants to enjoy sense gratification. For sense gratification, a man in the mode of passion wants some honor in society, or in the nation, and he wants to have a happy family, with nice children, wife and house. These are the products of the mode of passion. As long as one is hankering after these things, he has to work very hard. Therefore it is clearly stated here that he becomes associated with the fruits of his activities and thus becomes bound by such activities. In order to please his wife, children and society and to keep up his prestige, one has to work. Therefore, the whole material world is more or less in the mode of passion. Modern civilization is considered to be advanced in the standard of the mode of passion.” (BG 14.7 Purport)
The only remedy to get rid of this lower sexual urge is to develop a higher taste in devotional service to Lord Krsna.
“Bhakti-yoga leads to gradual evaporation of the sex desire, which is summarized in three headings, namely profit, adoration and distinction. All conditioned souls are mad after these different forms of sex desire, and one shall see for himself how much he has been freed from such material hankerings based primarily on the sex desire. As a person feels his hunger satisfied after eating each morsel of foodstuff, he must similarly be able to see the degree to which he has been freed from sex desire. The sex desire is diminished along with its various forms by the process of bhakti-yoga because bhakti-yoga automatically, by the grace of the Lord, effectively results in knowledge and renunciation, even if the devotee is not materially very well educated.” (SB 2.2.12 Purport)
There is a very famous quote from Yamunacarya.
yad-avadhi mama cetaḥ kṛṣṇa-pādāravinde
nava-nava-rasa-dhāmany udyataṁ rantum āsīt
tad-avadhi bata nārī-saṅgame smaryamāne
bhavati mukha-vikāraḥ suṣṭhu niṣṭhīvanaṁ ca
“Since I have been engaged in the transcendental loving service of Kṛṣṇa, realizing ever-new pleasure in Him, whenever I think of sex pleasure, I spit at the thought, and my lips curl with distaste.”
Sexual desire can be stopped only when one is fully Kṛṣṇa conscious, and not otherwise. As long as one has desires for sex, one must change his body and transmigrate from one body to another to enjoy sex in different species or forms. But although the forms may differ, the business of sex is the same. Therefore, it is said, punaḥ punaś carvita-carvaṇānām (SB 7.5.30).
All glories to Srila Prabhupada!
Krsna Katha 