FW: Index curves

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'
)