APPS.IGS_AD_GEN_005 dependencies on IGS_EN_CAT_MAPPING

Line 103: FROM IGS_EN_CAT_MAPPING ecm,

99: DECLARE
100: CURSOR c_ecm IS
101: SELECT ecm.enrolment_cat,
102: ec.description
103: FROM IGS_EN_CAT_MAPPING ecm,
104: IGS_EN_ENROLMENT_CAT ec
105: WHERE ecm.admission_cat = p_admission_cat AND
106: ecm.dflt_cat_ind = 'Y' AND
107: ec.enrolment_cat = ecm.enrolment_cat AND

Line 110: v_enrolment_cat IGS_EN_CAT_MAPPING.enrolment_cat%TYPE DEFAULT NULL;

106: ecm.dflt_cat_ind = 'Y' AND
107: ec.enrolment_cat = ecm.enrolment_cat AND
108: ec.closed_ind = 'N';
109: v_ecm_rec c_ecm%ROWTYPE;
110: v_enrolment_cat IGS_EN_CAT_MAPPING.enrolment_cat%TYPE DEFAULT NULL;
111: BEGIN
112: -- get the enrolment_cat record and check for Multiple Rows
113: FOR v_ecm_rec IN c_ecm LOOP
114: IF c_ecm%ROWCOUNT > 1 THEN