Possibility to capture SQL queries whlie using stored procedure

I have a question about APM.

When an application calls a stored procedure, does APM only shows the name of the stored procedure, without showing the actual SQL queries inside it?
if so, is it possible to show SQL queries while using stored procedure?

I can show SQL queries manually with codes but since we have so many applications managed by different people, I need to find if there's a way to show queries through options or a few settings without coding.

Removed server