109: a.course_cd,
110: b.title,
111: a.course_cd||'-'||b.title program,
112: a.person_id
113: from igs_en_stdnt_ps_att a,igs_ps_ver b
114: where a.course_cd = b.course_cd
115: and a.version_number = b.version_number
116: and a.person_id = p_person_id
117: and nvl(a.course_attempt_status,' ') not in ('INACTIVE');
1259: SELECT
1260: pv.course_cd,
1261: pv.version_number,
1262: pv.title
1263: FROM IGS_EN_STDNT_PS_ATT_ALL sca,
1264: IGS_PS_VER_ALL pv
1265: WHERE pv.course_cd = sca.course_cd
1266: AND pv.version_number = igs_en_spa_terms_api.get_spat_program_version(sca.person_id, sca.course_cd, p_term_cal_type,
1267: p_term_sequence_number)
1272: p_term_sequence_number) = 'PRIMARY';
1273:
1274:
1275:
1276: CURSOR get_secondary_prgm_dtls (p_course_code igs_en_stdnt_ps_att.course_cd%TYPE)IS
1277: SELECT pv.title
1278: FROM IGS_EN_STDNT_PS_ATT_ALL sca,
1279: IGS_PS_VER_ALL pv
1280: WHERE pv.course_cd = sca.course_cd
1274:
1275:
1276: CURSOR get_secondary_prgm_dtls (p_course_code igs_en_stdnt_ps_att.course_cd%TYPE)IS
1277: SELECT pv.title
1278: FROM IGS_EN_STDNT_PS_ATT_ALL sca,
1279: IGS_PS_VER_ALL pv
1280: WHERE pv.course_cd = sca.course_cd
1281: AND pv.version_number = sca.version_number
1282: AND sca.course_attempt_status IN ('ENROLLED','INACTIVE','INTERMIT')
2476:
2477: -- get the program title
2478: CURSOR c_prg_title (cp_person_id NUMBER,cp_program_cd VARCHAR2,cp_term_cal VARCHAR2,cp_term_seq_num NUMBER) IS
2479: SELECT pv.title
2480: FROM igs_en_stdnt_ps_att_all sca,
2481: igs_ps_ver_all pv
2482: WHERE pv.course_cd = sca.course_cd
2483: AND pv.version_number = sca.version_number
2484: AND sca.course_attempt_status IN ('ENROLLED','INACTIVE','INTERMIT')
2523: -- get the program title
2524: CURSOR c_sec_prg_title (cp_person_id NUMBER,cp_program_cd VARCHAR2,cp_version_number NUMBER,
2525: cp_term_cal VARCHAR2,cp_term_seq_num NUMBER) IS
2526: SELECT pv.title
2527: FROM igs_en_stdnt_ps_att_all sca,
2528: igs_ps_ver_all pv
2529: WHERE pv.course_cd = sca.course_cd
2530: AND pv.version_number = sca.version_number
2531: AND sca.course_attempt_status IN ('ENROLLED','INACTIVE','INTERMIT')
4386: --cursor to check if the passed in load calendar is associated with the academic calendar
4387: -- of any of the student's program attempts
4388: CURSOR c_check_is_load_assoc_to_acad (cp_person_id NUMBER, cp_load_cal_type VARCHAR2, cp_load_seq_num NUMBER) IS
4389: SELECT distinct cir.sub_cal_type ,cir.sub_ci_sequence_number
4390: FROM igs_en_stdnt_ps_att sca,
4391: igs_ca_inst_rel cir,
4392: igs_ca_type ct
4393: WHERE cir.sup_cal_type = sca.cal_type and
4394: ct.cal_type = cir.sub_cal_type and