APPS.IGS_EN_NSC_PKG dependencies on IGS_EN_STDNT_PS_ATT_ALL

Line 1490: FROM igs_en_stdnt_ps_att_all

1486:
1487: CURSOR c_program_data IS
1488: SELECT nominated_completion_yr ,
1489: nominated_completion_perd
1490: FROM igs_en_stdnt_ps_att_all
1491: WHERE person_id = p_student_data.student_id
1492: AND cal_type = p_acad_cal_type
1493: AND course_attempt_status IN ('COMPLETED', 'ENROLLED', 'INACTIVE', 'INTERMIT')
1494: ORDER BY NVL(nominated_completion_yr,-1) desc, decode(nominated_completion_perd,'E',1,'S',2,'M',3,0) desc;

Line 1773: l_attendance_type igs_en_stdnt_ps_att_all.attendance_type%TYPE;

1769: l_grad_date DATE;
1770: l_W_temp_date DATE;
1771: l_lp_temp_date DATE;
1772: l_message_name VARCHAR2(100);
1773: l_attendance_type igs_en_stdnt_ps_att_all.attendance_type%TYPE;
1774: l_code VARCHAR2(3);
1775: l_career_profile VARCHAR2(1);
1776:
1777: CURSOR c_enr_status (l_status VARCHAR2) IS

Line 2091: CURSOR c_other_sua ( cp_course_cd igs_en_stdnt_ps_att_all.course_cd%TYPE ) IS

2087: AND lod.load_cal_type = cp_load_cal_type
2088: AND lod.load_ci_sequence_number = cp_load_cal_seq;
2089:
2090: -- smaddali added these cursors for but#5440823
2091: CURSOR c_other_sua ( cp_course_cd igs_en_stdnt_ps_att_all.course_cd%TYPE ) IS
2092: SELECT sua.discontinued_dt
2093: FROM igs_en_su_attempt sua
2094: WHERE sua.person_id = p_student_id
2095: AND sua.course_cd = cp_course_cd

Line 2103: CURSOR c_disc_units(cp_course_cd igs_en_stdnt_ps_att_all.course_cd%TYPE) IS

2099: WHERE load_cal_type = p_load_cal_type AND load_ci_sequence_number = p_load_cal_seq
2100: );
2101: c_other_sua_rec c_other_sua%ROWTYPE;
2102:
2103: CURSOR c_disc_units(cp_course_cd igs_en_stdnt_ps_att_all.course_cd%TYPE) IS
2104: SELECT sua.discontinued_dt
2105: FROM igs_En_Su_Attempt sua
2106: WHERE person_id = p_student_id
2107: AND course_cd = cp_course_cd