[Home] [Help]
1378: sua.override_eftsu,
1379: sua.unit_attempt_status,
1380: sua.no_assessment_ind
1381: FROM IGS_EN_SU_ATTEMPT sua,
1382: IGS_EN_STDNT_PS_ATT sca,
1383: IGS_PS_VER crv,
1384: IGS_PS_UNIT_VER uv
1385: WHERE sua.person_id = p_matched_id AND
1386: sua.unit_attempt_status IN (
1410: SELECT cty.govt_course_type
1411: FROM IGS_PS_TYPE cty
1412: WHERE cty.course_type = cp_course_type;
1413: CURSOR c_pee (
1414: cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE) IS
1415: SELECT pee.s_encmb_effect_type
1416: FROM IGS_PE_PERSENC_EFFCT pee
1417: WHERE pee.person_id = cp_person_id AND
1418: pee.s_encmb_effect_type IN (
1418: pee.s_encmb_effect_type IN (
1419: cst_sus_srvc,
1420: cst_rvk_srvc);
1421: CURSOR c_pce (
1422: cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
1423: cp_course_cd IGS_PS_VER.course_cd%TYPE) IS
1424: SELECT pce.s_encmb_effect_type
1425: FROM IGS_PE_COURSE_EXCL pce
1426: WHERE pce.person_id = cp_person_id AND
1428: cst_exc_course,
1429: cst_sus_course) AND
1430: pce.course_cd = cp_course_cd;
1431: CURSOR c_pcge_cgr_cgm (
1432: cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
1433: cp_course_cd IGS_PS_VER.course_cd%TYPE) IS
1434: SELECT pcge.s_encmb_effect_type
1435: FROM IGS_PE_CRS_GRP_EXCL pcge,
1436: IGS_PS_GRP cgr,
1518: v_course_year_last_enr := 0;
1519: v_course_sem_first_enr := 9;
1520: v_course_sem_last_enr := 0;
1521: v_sca_total_eftsu := 0.00;
1522: -- Find any IGS_EN_STDNT_PS_ATT records that have
1523: -- IGS_EN_SU_ATTEMPT records for this student
1524: FOR v_sua_sca_rec IN c_sua_sca LOOP
1525: -- We can't write the subject record until we have
1526: -- all the details for the course attempt record.