Grant needed for table in dynamic SQL in a package?

[tamilselvan]

Yes.
You need to give SELECT privilege directly to user or role.