ROUTINE_TYPE = 'PROCEDURE' OR 'Function'

Select ROUTINE_TYPE,SPECIFIC_NAME,ROUTINE_DEFINITION

FROM INFORMATION_SCHEMA.ROUTINES

WHERE OBJECTPROPERTY(OBJECT_ID(SPECIFIC_NAME),'IsMSShipped') =0

AND ROUTINE_DEFINITION like '%prcleave%'

AND ROUTINE_TYPE='PROCEDURE'