Query Medical Claim

  • From: Kean Jacinta <jacintakean@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Wed, 26 Jan 2005 19:49:07 -0800 (PST)

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
--
//www.freelists.org/webpage/oracle-l

Other related posts: