Drilling holes thru joists etc often have rules to meet Building Codes because Drilling for Pipes can made the joist(s) weak and fail days, months or years later depending just how big and where the holes are.
3/4" pipe alone needs 7/8-1" hole minimum. Insulated pipe needs 2" or more hole...
Likely has problem(s) now...
Bath line that some fool basically cut the joist making that worthless Likely was Doubled to take load for bath tub or other heavy thing(s), same reason the double joist to the left.
If pass inspection like that then inspector didn't look because incompetent or worse.
------------------
Dr. Ian Malcolm: Yeah, but your scientists were so preoccupied with whether or not they could, they didn't stop to think if they should.
(Jurassic Park)
The Ogre's Fiero Cave