APPS.IGS_EN_GEN_002 dependencies on IGS_EN_GEN_014

Line 84: SELECT IGS_EN_GEN_014.enrs_get_acad_alt_cd(SUAV.cal_type,SUAV.ci_sequence_number)

80: v_first_enrolment_course VARCHAR2(25);
81: CURSOR c_suav_details (
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

Line 765: IGS_EN_GEN_014.ENRS_GET_WITHIN_CI(

761: SELECT 'x'
762: FROM IGS_AS_SC_ATMPT_ENR scae
763: WHERE scae.person_id = p_person_id AND
764: scae.course_cd = p_course_cd AND
765: IGS_EN_GEN_014.ENRS_GET_WITHIN_CI(
766: p_acad_cal_type,
767: p_acad_sequence_number,
768: scae.cal_type,
769: scae.ci_sequence_number,