The following query can be used to get details such as when the Stored Procedure was last updated — as well as its content.
SELECT
CREATED,
LAST_ALTERED,
SPECIFIC_NAME,
ROUTINE_SCHEMA,
ROUTINE_NAME,
ROUTINE_DEFINITION
FROM lms_db.INFORMATION_SCHEMA.ROUTINES
WHERE routine_type = 'PROCEDURE'
ORDER BY ROUTINE_SCHEMA, ROUTINE_NAME