Expense Claims Approval Repository

Data access layer for expense approval workflow operations against the expense_claims, expense_items, expense_receipts, and declarations tables. Provides typed read and write methods used by both the query service and the approval service, including transactional update helpers for atomic status changes with audit log co-writes.

Feature: Expense Approval Queue

expense-claims-approval-repository

• Query expense claims with filtering, pagination, and organization scoping
• Update claim status, approved_by, approved_at, and rejection_reason within a transaction
• Fetch full claim detail with joined expense items, receipts, and declarations
• Support batch update for bulk-approve operations within a single transaction
• Provide claim count queries by status for dashboard KPI integration