394: IGS_CA_INST_ALL loadcal,
395: IGS_CA_INST_REL acadterm,
396: IGS_CA_TYPE cat2,
397: IGS_CA_STAT cs2 ,
398: IGS_ST_DFT_LOAD_APPO l2t,
399: IGS_ST_DFT_LOAD_APPO l2tsua2
400:
401: WHERE sua1.person_id = p_person_id
402: AND sua1.course_cd = p_course_cd
395: IGS_CA_INST_REL acadterm,
396: IGS_CA_TYPE cat2,
397: IGS_CA_STAT cs2 ,
398: IGS_ST_DFT_LOAD_APPO l2t,
399: IGS_ST_DFT_LOAD_APPO l2tsua2
400:
401: WHERE sua1.person_id = p_person_id
402: AND sua1.course_cd = p_course_cd
403: AND sua1.unit_attempt_status = cst_enrolled