APPS.IGS_SS_ENROLL_PKG dependencies on IGS_EN_STDNT_PS_ATT

Line 375: from igs_en_stdnt_ps_att a

371: begin
372: SELECT
373: a.course_cd
374: into l_course_cd
375: from igs_en_stdnt_ps_att a
376: where nvl(a.course_attempt_status,' ') not in ('INACTIVE')
377: and person_id = p_person_id ;
378: exception when others
379: then

Line 591: FROM igs_en_stdnt_ps_att

587:
588: -- Get the academic calendar
589: CURSOR c_acad_cal(cp_person_id NUMBER, cp_program_cd VARCHAR2) IS
590: SELECT cal_type
591: FROM igs_en_stdnt_ps_att
592: WHERE person_id = cp_person_id AND
593: course_cd = cp_program_cd;
594:
595: l_acad_year_flag igs_en_ss_disp_stps.academic_year_flag%TYPE;

Line 701: FROM igs_en_stdnt_ps_att

697:
698: -- Get the academic calendar
699: CURSOR c_acad_cal(cp_person_id NUMBER, cp_program_cd VARCHAR2) IS
700: SELECT cal_type
701: FROM igs_en_stdnt_ps_att
702: WHERE person_id = cp_person_id AND
703: course_cd = cp_program_cd;
704:
705: l_acad_year_flag igs_en_ss_disp_stps.academic_year_flag%TYPE;

Line 1090: CURSOR cur_prg_atmpt(cp_program_cd igs_en_stdnt_ps_att.course_cd%TYPE) IS

1086: AND course_cd = p_program_cd
1087: AND uoo_id = p_uoo_id;
1088: l_c_transfer_course_cd igs_ps_stdnt_unt_trn.transfer_course_cd%TYPE;
1089:
1090: CURSOR cur_prg_atmpt(cp_program_cd igs_en_stdnt_ps_att.course_cd%TYPE) IS
1091: SELECT course_type
1092: FROM igs_en_stdnt_ps_att sca,
1093: igs_ps_ver cv
1094: WHERE sca.person_id = p_person_id

Line 1092: FROM igs_en_stdnt_ps_att sca,

1088: l_c_transfer_course_cd igs_ps_stdnt_unt_trn.transfer_course_cd%TYPE;
1089:
1090: CURSOR cur_prg_atmpt(cp_program_cd igs_en_stdnt_ps_att.course_cd%TYPE) IS
1091: SELECT course_type
1092: FROM igs_en_stdnt_ps_att sca,
1093: igs_ps_ver cv
1094: WHERE sca.person_id = p_person_id
1095: AND sca.course_cd = cp_program_cd
1096: AND cv.course_cd = sca.course_cd