After looking over the internet, It looks like I have a bad piston. I recalled that it was hard to push the left piston in and I could not push it in all the way (about 5mm left compared to the right one).
I still don't know why I heard the noise from my transmission (inside the cabin) only when I step on the brake when the transmission is in P position.
Please help!