nicdubon-ctx

--------- US RECALL VIEW - TRANSACTION RECENCY (what # transaction was the recall)

WITH fraud_funded_trips AS (
    SELECT
        d.triggered_trip_id AS trip_id
    FROM public.lead_bank_funds_requests lbfr
    INNER JOIN public.deposits d ON lbfr.deposit_id = d.id
    WHERE lbfr.fraud = true
      AND lbfr.institution = 'lead_bank'
),