Just wanted to know whether the card's response affected all discard piles? or just a(one) chosen by the player of the card?

All of them. His ability should be used wisely. But it only affects the recent kills, mind you.