From a note in Bhikkhu Bodhi's translation of the Sa.myutta Nikaaya,
I believe your book refers to the Channa Sutta (SN 22.90, PTS iii.132
ff), but the details you mention appear only in the commentary
(Saratthappakaasinii, a.k.a. Sa.myutta Nikaaya-a.t.thakathaa).