[Home] [Help]
62: --and also the Load Calendar is ACTIVE and the dates lie between the start and end dates
63: --can be checked to lie within the Load Calendar Dates
64: CURSOR cur_term_date IS
65: SELECT MAX(ci.start_dt)
66: FROM IGS_CA_INST_ALL ci,
67: IGS_CA_TYPE ct,
68: IGS_CA_STAT ca
69: WHERE ci.cal_type = ct.cal_type
70: AND ct.s_cal_cat = 'LOAD'