APPS.IGS_EN_GEN_016 dependencies on IGS_EN_STDNT_PS_ATT_ALL

Line 82: FROM igs_en_stdnt_ps_att_all sca

78: --cursor to get all INACTIVE program attempts
79: --
80: CURSOR get_prgm_dtls (p_course_cd IN VARCHAR2 , p_cal_type IN VARCHAR2 , p_person_id IN NUMBER) IS
81: SELECT sca.course_cd , sca.version_number , sca.cal_type,sca.course_attempt_status
82: FROM igs_en_stdnt_ps_att_all sca
83: WHERE sca.course_cd = NVL(p_course_cd,sca.course_cd) AND
84: sca.course_attempt_status IN ('INACTIVE','ENROLLED') AND
85: sca.cal_type = p_cal_type AND
86: sca.person_id = p_person_id ;

Line 169: l_course_cd igs_en_stdnt_ps_att_all.course_cd%TYPE;

165: l_teach_cal_type igs_ca_type.cal_type%TYPE;
166: l_teach_ci_Sequence_number igs_ca_inst.sequence_number%TYPE;
167:
168: l_error_status VARCHAR2(1);
169: l_course_cd igs_en_stdnt_ps_att_all.course_cd%TYPE;
170: l_course_version_number igs_en_stdnt_ps_att_all.version_number%TYPE;
171: l_del_int_rec VARCHAR2(1) := 'Y';
172:
173: l_return_status VARCHAR2(10) ;

Line 170: l_course_version_number igs_en_stdnt_ps_att_all.version_number%TYPE;

166: l_teach_ci_Sequence_number igs_ca_inst.sequence_number%TYPE;
167:
168: l_error_status VARCHAR2(1);
169: l_course_cd igs_en_stdnt_ps_att_all.course_cd%TYPE;
170: l_course_version_number igs_en_stdnt_ps_att_all.version_number%TYPE;
171: l_del_int_rec VARCHAR2(1) := 'Y';
172:
173: l_return_status VARCHAR2(10) ;
174: l_prgm_val_pass VARCHAR2(1) := 'N' ;