APPS.IGS_AD_VAL_AA dependencies on IGS_CO_CAT_MAP

Line 453: FROM IGS_CO_CAT_MAP ccm

449: WHERE ac.admission_cat = p_admission_cat;
450: CURSOR c_ccm IS
451: SELECT ccm.admission_cat,
452: COUNT(*)
453: FROM IGS_CO_CAT_MAP ccm
454: WHERE ccm.admission_cat = p_admission_cat AND
455: ccm.dflt_cat_ind = 'Y'
456: GROUP BY ccm.admission_cat;
457: CURSOR c_ecm IS

Line 476: -- one default IGS_CO_CAT_MAP record.

472: -- Validate the IGS_AD_APPL.admission_cat.
473: -- Validations are:
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.