APPS.IGS_EN_GEN_002 dependencies on IGS_EN_SU_ATTEMPT

Line 86: FROM IGS_EN_SU_ATTEMPT SUAV,

82: cp_person_id IGS_PE_PERSON.person_id%TYPE,
83: cp_course_cd IGS_PS_COURSE.course_cd%TYPE) IS
84: SELECT IGS_EN_GEN_014.enrs_get_acad_alt_cd(SUAV.cal_type,SUAV.ci_sequence_number)
85: ||'/'|| IGS_CA_GEN_001.calp_get_alt_cd(SUAV.cal_type,SUAV.ci_sequence_number)
86: FROM IGS_EN_SU_ATTEMPT SUAV,
87: IGS_CA_INST CI
88: WHERE SUAV.person_id = cp_person_id AND
89: SUAV.course_cd = cp_course_cd AND
90: SUAV.enrolled_dt IS NOT NULL AND