APPS.IGS_AD_VAL_AA dependencies on IGS_EN_CAT_MAPPING

Line 460: FROM IGS_EN_CAT_MAPPING ecm

456: GROUP BY ccm.admission_cat;
457: CURSOR c_ecm IS
458: SELECT ecm.admission_cat,
459: COUNT(*)
460: FROM IGS_EN_CAT_MAPPING ecm
461: WHERE ecm.admission_cat = p_admission_cat AND
462: ecm.dflt_cat_ind = 'Y'
463: GROUP BY ecm.admission_cat;
464: CURSOR c_fcm IS

Line 478: -- one default IGS_EN_CAT_MAPPING record.

474: -- IGS_AD_APPL.admission_cat must not be closed.
475: -- IGS_AD_APPL.admission_cat must have one and only
476: -- one default IGS_CO_CAT_MAP record.
477: -- IGS_AD_APPL.admission_cat must have one and only
478: -- one default IGS_EN_CAT_MAPPING record.
479: -- IGS_AD_APPL.admission_cat must have one and only
480: -- one default IGS_FI_FEE_CAT_MAP record.
481: OPEN c_ac;
482: FETCH c_ac INTO v_closed_ind;