[Home] [Help]
1616:
1617: -- Get the academic calendar type and student instance number of the current program attempt.
1618: CURSOR c_acad_cal IS
1619: SELECT a.cal_type,b.student_inst_number
1620: FROM igs_en_stdnt_ps_att_all a , igs_he_st_spa_all b
1621: WHERE a.person_id = p_person_id AND
1622: a.course_cd = p_course_cd AND
1623: a.person_id = b.person_id AND
1624: a.course_cd = b.course_cd ;
1632: -- mandatorily transfer all his unit and unit set attempts , Thus they will be counted in the
1633: -- latest calendar.
1634: -- smaddali 29-oct-03 modified to add condition enrolled_dt <= p_enr_end_dt for bug#3224246
1635: CURSOR c_yos (p_student_inst_number igs_he_st_spa_all.student_inst_number%TYPE,
1636: p_cal_type igs_en_stdnt_ps_att_all.cal_type%TYPE ) IS
1637: SELECT COUNT (DISTINCT cir.sup_ci_sequence_number || cir.sup_cal_type)
1638: FROM igs_he_st_spa_all spa ,
1639: igs_en_stdnt_ps_att sca,
1640: igs_en_su_attempt sua,
5084: CURSOR c_spa_dt IS
5085: SELECT commencement_dt,
5086: discontinued_dt,
5087: course_rqrmnts_complete_dt
5088: FROM igs_en_stdnt_ps_att_all
5089: WHERE person_id = p_person_id
5090: AND course_cd = p_course_cd
5091: AND version_number = p_version_number;
5092:
6427: CURSOR c_spa_dt IS
6428: SELECT commencement_dt,
6429: discontinued_dt,
6430: course_rqrmnts_complete_dt
6431: FROM igs_en_stdnt_ps_att_all
6432: WHERE person_id = p_person_id
6433: AND course_cd = p_course_cd
6434: AND version_number = p_version_number;
6435:
6780: --Cursor to get the commencement date of the first porgram in chain for the context person from
6781: -- IGS_HE_ST_SPA having same instance number
6782: CURSOR c_list_crs_trn IS
6783: SELECT MIN(sca.commencement_dt) commencement_dt
6784: FROM igs_en_stdnt_ps_att_all sca,
6785: igs_he_st_spa_all hspa
6786: WHERE hspa.person_id = p_person_id
6787: AND hspa.student_inst_number = p_student_inst_number
6788: AND sca.person_id = hspa.person_id