[Home] [Help]
568: AND SYSDATE BETWEEN ci.start_dt AND ci.end_dt
569: AND dai.cal_type = ci.cal_type
570: AND dai.ci_sequence_number = ci.sequence_number
571: AND dai.dt_alias = (SELECT load_effect_dt_alias
572: FROM igs_en_cal_conf)
573: AND dai.absolute_val <= SYSDATE
574: ORDER BY dai.absolute_val DESC) currterm
575: WHERE ROWNUM < 2;
576: