Update of /cvsroot/oscarmcmaster/oscar_mcmaster/web/billing/CA/BC
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv16012
Modified Files:
dbBilling.jsp
Log Message:
added query search_service_price
Index: dbBilling.jsp
===================================================================
RCS file: /cvsroot/oscarmcmaster/oscar_mcmaster/web/billing/CA/BC/dbBilling.jsp,v
retrieving revision 1.11
retrieving revision 1.12
diff -C2 -d -r1.11 -r1.12
*** dbBilling.jsp 1 Oct 2004 04:33:03 -0000 1.11
--- dbBilling.jsp 4 Nov 2004 17:09:59 -0000 1.12
***************
*** 102,105 ****
--- 102,106 ----
{"search_rasummary", "select r.service_count, r.error_code, r.amountclaim, b.visittype, b.billing_no, r.service_code, r.service_date, r.providerohip_no, r.amountpay, p.last_name, p.first_name from radetail r, billing b, provider p where r.raheader_no=? and b.billing_no=r.billing_no and p.ohip_no=r.providerohip_no and r.providerohip_no like ?"},
{"search_service_code", "select service_code, description from billingservice where service_code like ? or service_code like ? or service_code like ? or description like ? or description like ? or description like ?"},
+ {"search_service_price", "select value from billingservice where service_code = ?"},
{"search_research_code", "select ichppccode, description from ichppccode where ichppccode like ? or ichppccode like ? or ichppccode like ? or description like ? or description like ? or description like ?"},
{"save_billactivity", "insert into billactivity values(?,?,?,?,?,?,?,?,?,?,?,?,?)"},
|