Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Query Medical Claim

Query Medical Claim

From: Kean Jacinta <jacintakean_at_yahoo.com>
Date: Wed, 26 Jan 2005 19:49:07 -0800 (PST)
Message-ID: <20050127034908.40000.qmail@web52907.mail.yahoo.com>


Hi,

I need some help here. I wanted to generate a report showing : emp_name, emp_id, med_id, medical_type, entitlement, used, balance.

TBL_EMPMEDICAL
emp_code, 
emp_id, 
med_id,

amountused  

TBL_MEDICAL_TYPES

Med_ID  MediType      Entitlement

------------------------------------
M01 supmed unlimited M02 execmed 5000 M0 execmedopt 8000

Each type of medical type have max amount of entitlement

I really need to solved this quick. Can someone help me out with this.

Your help is very much appreciated
Thank You

JK                 



Do you Yahoo!?
Yahoo! Mail - Easier than ever with enhanced search. Learn more. http://info.mail.yahoo.com/mail_250
--

http://www.freelists.org/webpage/oracle-l Received on Wed Jan 26 2005 - 22:51:37 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US