url.ID=decrypt(#url.ID#,"54kczhzgHTj4a8n+SRZPyg==","AES","Hex");
SELECT Visit_Type, Description, Rev_Code, HCPCS, EClaim_Price, Quick_Books_Price, Measure, Payer_ID,TimeAuthorization, Modifier
FROM #Request.prefix_db_agency#.Revenue_Code
WHERE Rev_CodeID = #url.ID#
SELECT Payer_ID, PayName
FROM #Request.prefix_db_agency#.Payer
WHERE Agency_ID = #session.AgencyID#
GROUP BY PayName
ORDER BY PayName