SELECT NAME, TYPE, LINE, TEXT
FROM USER_SOURCE
WHERE TYPE = 'PROCEDURE'
  AND UPPER(TEXT) LIKE '%PALABRA%';