---

-- Ищем процедуры/функции, которые работают с payment_register
-- и создают операции одновременно
SELECT routine_schema, routine_name, routine_definition
FROM information_schema.routines
WHERE routine_type IN ('PROCEDURE', 'FUNCTION')
  AND routine_schema = 'back_office'
  AND routine_definition ILIKE '%payment_register%'
  AND routine_definition ILIKE '%operation%'
ORDER BY routine_name;




-- Ищем что вызывается с кодом EOMPw12D (принятие реестра)
SELECT routine_schema, routine_name, routine_definition
FROM information_schema.routines
WHERE routine_type IN ('PROCEDURE', 'FUNCTION')
  AND routine_schema = 'back_office'
  AND routine_definition ILIKE '%payment_register%'
  AND routine_definition ILIKE '%accepted%'
ORDER BY routine_name;