---

SELECT
    n.nspname AS routine_schema,
    p.proname AS routine_name,
    p.oid::regprocedure AS routine_signature
FROM pg_proc p
JOIN pg_namespace n
    ON n.oid = p.pronamespace
WHERE p.prokind IN ('f', 'p')
  AND p.prosrc ILIKE '%npf360_to_lkk_notification_logs%'
ORDER BY
    n.nspname,
    p.proname;