APPS.IGS_SS_ENR_DETAILS dependencies on IGS_EN_SU_ATTEMPT_ALL

Line 1655: FROM igs_ca_teach_to_load_v ttl, igs_en_su_attempt_all sua

1651:
1652: --ijeddy modified the cursor for bug 3724930
1653: CURSOR c_term_info_ccd IS
1654: SELECT ttl.load_cal_type, ttl.load_ci_sequence_number, ttl.load_description
1655: FROM igs_ca_teach_to_load_v ttl, igs_en_su_attempt_all sua
1656: WHERE ttl.teach_cal_type = sua.cal_type
1657: AND ttl.teach_ci_sequence_number = sua.ci_sequence_number
1658: AND sua.unit_attempt_status = 'ENROLLED'
1659: AND sua.person_id = p_person_id

Line 1666: FROM igs_ca_teach_to_load_v ttl, igs_en_su_attempt_all sua

1662:
1663:
1664: CURSOR c_term_info IS
1665: SELECT ttl.load_cal_type, ttl.load_ci_sequence_number, ttl.load_description
1666: FROM igs_ca_teach_to_load_v ttl, igs_en_su_attempt_all sua
1667: WHERE ttl.teach_cal_type = sua.cal_type
1668: AND ttl.teach_ci_sequence_number = sua.ci_sequence_number
1669: AND sua.unit_attempt_status = 'ENROLLED'
1670: AND sua.person_id = p_person_id

Line 4125: FROM IGS_EN_SU_ATTEMPT_ALL sua,

4121: CURSOR c_invalid_sub(cp_c_course_cd IN VARCHAR2,
4122: cp_n_person_id IN NUMBER,
4123: cp_n_uoo_id IN NUMBER) IS
4124: SELECT 1
4125: FROM IGS_EN_SU_ATTEMPT_ALL sua,
4126: IGS_PS_UNIT_OFR_OPT_ALL uoo
4127: WHERE sua.uoo_id = uoo.uoo_id
4128: AND uoo.sup_uoo_id = cp_n_uoo_id
4129: AND sua.course_cd = cp_c_course_cd

Line 4140: FROM IGS_EN_SU_ATTEMPT_ALL sua,

4136: cp_n_person_id IN NUMBER,
4137: cp_n_uoo_id IN NUMBER) IS
4138: SELECT sua.uoo_id,
4139: sua.core_indicator_code
4140: FROM IGS_EN_SU_ATTEMPT_ALL sua,
4141: IGS_PS_UNIT_OFR_OPT_ALL uoo
4142: WHERE sua.uoo_id = uoo.uoo_id
4143: AND uoo.sup_uoo_id = cp_n_uoo_id
4144: AND sua.course_cd = cp_c_course_cd

Line 5239: l_core_ind_cd igs_en_su_attempt_all.CORE_INDICATOR_CODE%TYPE;

5235:
5236: l_unit_cd igs_ps_unit_ofr_opt.unit_cd%TYPE;
5237: l_unit_class igs_ps_unit_ofr_opt.unit_class%TYPE;
5238: l_core_meaning igs_lookup_values.meaning%TYPE;
5239: l_core_ind_cd igs_en_su_attempt_all.CORE_INDICATOR_CODE%TYPE;
5240: BEGIN
5241: -- Get the Unit Code
5242: OPEN cur_unit_cd(p_uoo_id);
5243: FETCH cur_unit_cd INTO l_unit_cd,l_unit_class, l_core_ind_cd;