Just like the penetrations made by HVAC and other vents, plumbing stack vents can be planned for and well sealed with the use of gaskets and sealants.
Keep in mind the rule of Positive Overlaps - think like a drop of water! When installing a boot (like the one shown below) your weather barrier should go over the top and under the bottom of the flange.