APPS.IGS_IN_GEN_001 dependencies on IGS_EN_ENROLMENT_CAT

Line 591: v_description IGS_EN_ENROLMENT_CAT.description%TYPE;

587: gv_other_detail VARCHAR2(255);
588: BEGIN -- inqp_get_enr_cat
589: DECLARE
590: v_enrolment_cat IGS_AS_SC_ATMPT_ENR.enrolment_cat%TYPE;
591: v_description IGS_EN_ENROLMENT_CAT.description%TYPE;
592: CURSOR c_scae IS
593: SELECT scae.enrolment_cat,
594: ec.description
595: FROM IGS_AS_SC_ATMPT_ENR scae,

Line 597: IGS_EN_ENROLMENT_CAT ec

593: SELECT scae.enrolment_cat,
594: ec.description
595: FROM IGS_AS_SC_ATMPT_ENR scae,
596: IGS_CA_INST ci,
597: IGS_EN_ENROLMENT_CAT ec
598: WHERE scae.person_id = p_person_id AND
599: scae.course_cd =p_course_cd AND
600: ci.cal_type = scae.cal_type AND
601: ci.sequence_number =ci_sequence_number AND