payments table uses related_entity_type/related_entity_id, not
payment_request_id. Simplified query to filter by payment_type directly.
Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>