Delete curves ,
 select curve_def_id curve_cd, book_type_cd, curve_type_cd,insert_user_nm
from egs_curve_def
where effective_dt = trunc(sysdate)
 
  CURVE_CD B CURV INSERT_USER_NM
---------- - ---- ------------------------------
   3118799 P AP   DQUIGLE
   3118795 P AV   DQUIGLE
   3118800 P BP   DQUIGLE
   3118796 P BV   DQUIGLE
   3118797 I PR   DQUIGLE
   3118801 P PR   DQUIGLE
   3118798 P VO   DQUIGLE
7 rows selected.

as instructed, I deleted the two NG, P,PR price curves and the NG,P,VO volatility curves
from production today. However, it looks like there where a total of 7 curves inserted
into the system. They are all NG curves, do you want to keep them?
errol.mclaughlin@enron.com