APPS.IGS_AD_VAL_AA dependencies on IGS_FI_FEE_CAT_MAP

Line 467: FROM IGS_FI_FEE_CAT_MAP fcm

463: GROUP BY ecm.admission_cat;
464: CURSOR c_fcm IS
465: SELECT fcm.admission_cat,
466: COUNT(*)
467: FROM IGS_FI_FEE_CAT_MAP fcm
468: WHERE fcm.admission_cat = p_admission_cat AND
469: fcm.dflt_cat_ind = 'Y'
470: GROUP BY fcm.admission_cat;
471: BEGIN

Line 480: -- one default IGS_FI_FEE_CAT_MAP record.

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;
483: IF (c_ac%FOUND) THEN
484: IF (v_closed_ind = 'Y') THEN