I am still waiting for your reply.

 -----Original Message-----
From: 	Lim, Francis S.  
Sent:	Wednesday, September 26, 2001 11:39 AM
To:	Wolfe, Jason
Subject:	Index curves

Jason,

	The Gas Daily Curves are loaded into the system everyday at 6AM
	or something when they have problems, the curves are loaded at
	around 11AM. I can get these curves as soon as they get it.
	However, Index curves are loaded by GGREENA, CFRANK2, and CRABON
	at around 3PM or 4PM. I will not be able to get these curves.
	I can get Yesterdays Index curves.


select effective_dt,curve_cd, book_type_cd, curve_type_cd, ref_period_dt, curve_amt
 from egs_curves
where effective_dt = trunc(sysdate)
and curve_cd like 'GD%'
and book_type_cd = 'D'
and curve_type_cd = 'SP'

select effective_dt,curve_cd, book_type_cd, curve_type_cd, ref_period_dt, curve_amt
 from egs_curves
select * from egs_curve_def
where effective_dt = trunc(sysdate-1)
and book_type_cd = 'I'
and curve_type_cd = 'PR'
and curve_cd in (
'NGI-PGE/CG',
'NGI-SOCAL',
'IF-ELPO/SJ',
'IF-ELPO/PERMIAN',
'IF-WAHA-TX',
'NGI-MALIN',
'NGI-PGE/TOPOCK',
'NGI-SOBDR-SOCAL',
'NGI-SOBDR-PG&E',
'IF-NWPL_ROCKY_M',
'IF-NTHWST/CANBR'
)