---

-- Ищем во всех схемах
SELECT routine_schema, routine_name
FROM information_schema.routines
WHERE routine_type IN ('PROCEDURE', 'FUNCTION')
  AND routine_definition ILIKE '%accrual_repurchase_amount_payments%'
  AND routine_definition ILIKE '%insert into back_office.payment%'
ORDER BY routine_schema, routine_name;





SELECT routine_schema, routine_name
FROM information_schema.routines
WHERE routine_type IN ('PROCEDURE', 'FUNCTION')
  AND routine_definition ILIKE '%accrual_repurchase%'
  AND routine_definition ILIKE '%payment%'
  AND routine_definition ILIKE '%insert%'
ORDER BY routine_schema, routine_name;