[Home] [Help]
361: CURSOR c_cv IS
362: SELECT cs.s_course_status,
363: cv.expiry_dt
364: FROM IGS_PS_VER cv,
365: IGS_PS_STAT cs
366: WHERE cv.course_cd = p_course_cd AND
367: cv.version_number = p_to_crs_version_number AND
368: cs.COURSE_STATUS = cv.COURSE_STATUS;
369: v_cv_rec c_cv%ROWTYPE;