APPS.IGF_SP_GEN_001 dependencies on IGS_EN_SU_ATTEMPT

Line 345: cp_course_cd igs_en_su_attempt.course_cd%TYPE,

341: /*
342: cursor to see whether the student is actively enrolled in the unit or not
343: */
344: CURSOR c_enroll (cp_person_id igs_pe_person.person_id%TYPE,
345: cp_course_cd igs_en_su_attempt.course_cd%TYPE,
346: cp_unit_cd igs_en_su_attempt.unit_cd%TYPE,
347: cp_unit_version_number igs_en_su_attempt.version_number%TYPE,
348: cp_ld_cal_type igs_ca_inst.cal_type%TYPE,
349: cp_ld_ci_sequence_number igs_ca_inst.sequence_number%TYPE) IS

Line 346: cp_unit_cd igs_en_su_attempt.unit_cd%TYPE,

342: cursor to see whether the student is actively enrolled in the unit or not
343: */
344: CURSOR c_enroll (cp_person_id igs_pe_person.person_id%TYPE,
345: cp_course_cd igs_en_su_attempt.course_cd%TYPE,
346: cp_unit_cd igs_en_su_attempt.unit_cd%TYPE,
347: cp_unit_version_number igs_en_su_attempt.version_number%TYPE,
348: cp_ld_cal_type igs_ca_inst.cal_type%TYPE,
349: cp_ld_ci_sequence_number igs_ca_inst.sequence_number%TYPE) IS
350: SELECT 'x'

Line 347: cp_unit_version_number igs_en_su_attempt.version_number%TYPE,

343: */
344: CURSOR c_enroll (cp_person_id igs_pe_person.person_id%TYPE,
345: cp_course_cd igs_en_su_attempt.course_cd%TYPE,
346: cp_unit_cd igs_en_su_attempt.unit_cd%TYPE,
347: cp_unit_version_number igs_en_su_attempt.version_number%TYPE,
348: cp_ld_cal_type igs_ca_inst.cal_type%TYPE,
349: cp_ld_ci_sequence_number igs_ca_inst.sequence_number%TYPE) IS
350: SELECT 'x'
351: FROM igs_en_su_attempt

Line 351: FROM igs_en_su_attempt

347: cp_unit_version_number igs_en_su_attempt.version_number%TYPE,
348: cp_ld_cal_type igs_ca_inst.cal_type%TYPE,
349: cp_ld_ci_sequence_number igs_ca_inst.sequence_number%TYPE) IS
350: SELECT 'x'
351: FROM igs_en_su_attempt
352: WHERE person_id = cp_person_id
353: AND course_cd = cp_course_cd
354: AND unit_attempt_status IN ('ENROLLED', 'COMPLETED')
355: AND unit_cd = cp_unit_cd