I think this also works.

SELECT ROUTINE_NAME, ROUTINE_DEFINITION

FROM INFORMATION_SCHEMA.ROUTINES

WHERE ROUTINE_DEFINITION LIKE '%some_text%'

AND ROUTINE_TYPE='PROCEDURE'