SELECT Rev_Code, HCPCS, Visit_Type,Rev_CodeID, Measure,Description
FROM #Request.prefix_db_agency#.Revenue_Code
WHERE Agency_ID = '#session.AgencyID#'
And EClaim_Price IS NOT NULL
And RevenueCodeStatus = 'active'
And Quick_Books_Price IS NOT NULL
And Payer_ID = '#url.desc#'
order by Visit_Type