aboutsummaryrefslogtreecommitdiff
path: root/src/exchangedb/exchange_do_insert_programmatic_legitimization_outcome.sql
diff options
context:
space:
mode:
Diffstat (limited to 'src/exchangedb/exchange_do_insert_programmatic_legitimization_outcome.sql')
-rw-r--r--src/exchangedb/exchange_do_insert_programmatic_legitimization_outcome.sql12
1 files changed, 0 insertions, 12 deletions
diff --git a/src/exchangedb/exchange_do_insert_programmatic_legitimization_outcome.sql b/src/exchangedb/exchange_do_insert_programmatic_legitimization_outcome.sql
index 196632b44..ef0cb8fdb 100644
--- a/src/exchangedb/exchange_do_insert_programmatic_legitimization_outcome.sql
+++ b/src/exchangedb/exchange_do_insert_programmatic_legitimization_outcome.sql
@@ -154,18 +154,6 @@ INSERT INTO kyc_alerts
(in_h_payto,1)
ON CONFLICT DO NOTHING;
-IF in_to_investigate
-THEN
- INSERT INTO aml_status
- (h_payto
- ,status)
- VALUES
- (in_h_payto
- ,1)
- ON CONFLICT (h_payto) DO
- UPDATE SET status=EXCLUDED.status | 1;
-END IF;
-
FOR i IN 1..COALESCE(array_length(ina_events,1),0)
LOOP