SELECT * FROM #Request.prefix_db_agency#.pRevenue_Code
WHERE Status = 0
AND pRevenue_Code.Payer_ID =
AND Agency_ID =
AND pRevenue_Code.Visit_Type =
AND pRevenue_Code.Visit_Type =
AND pRevenue_Code.Visit_Type =
AND (
pRevenue_Code.Visit_Type =
OR pRevenue_Code.Visit_Type =
OR pRevenue_Code.Visit_Type =
OR pRevenue_Code.Visit_Type =
OR pRevenue_Code.Visit_Type =
OR pRevenue_Code.HCPCS =
OR pRevenue_Code.HCPCS =
OR pRevenue_Code.Description LIKE
OR pRevenue_Code.Description LIKE
)
AND (
pRevenue_Code.Visit_Type =
OR pRevenue_Code.Visit_Type =
)
AND pRevenue_Code.Visit_Type =
AND (
pRevenue_Code.Contract_Rate_Effective_Date IS NULL
OR pRevenue_Code.Contract_Rate_Effective_Date <=
)
AND (
pRevenue_Code.Contract_Rate_End_Date IS NULL
OR pRevenue_Code.Contract_Rate_End_Date >=
)
ORDER BY HCPCS, Description
>#HCPCS# - #Description#