---

SELECT
    n.nspname AS schema_name,
    p.proname AS function_name,
    p.oid
FROM pg_proc p
JOIN pg_namespace n
    ON n.oid = p.pronamespace
WHERE (
        p.prosrc ILIKE '%contribution_ss%'
        OR p.prosrc ILIKE '%contribution_sr%'
      )
  AND p.prosrc ILIKE '%prod_line%'
ORDER BY n.nspname, p.proname;