DECLARE @AsOfDate date = '2025-05-13'

SELECT SUM(AgingAmount)
FROM EDD..ARAgingDetail
WHERE AsOfDate = @AsOfDate

SELECT SUM(AgingAmount)
FROM CCH_ENT..UVW_ARAgingDetail
WHERE BalanceDate <= @AsOfDate