APPS.IGS_AD_GEN_005 dependencies on IGS_FI_FEE_CAT_MAP

Line 149: FROM IGS_FI_FEE_CAT_MAP fcm,

145: DECLARE
146: CURSOR c_fcm IS
147: SELECT fcm.fee_cat,
148: fc.description
149: FROM IGS_FI_FEE_CAT_MAP fcm,
150: IGS_FI_FEE_CAT fc
151: WHERE admission_cat = p_admission_cat AND
152: dflt_cat_ind = 'Y' AND
153: fc.fee_cat = fcm.fee_cat AND

Line 156: v_fee_cat IGS_FI_FEE_CAT_MAP.fee_cat%TYPE DEFAULT NULL;

152: dflt_cat_ind = 'Y' AND
153: fc.fee_cat = fcm.fee_cat AND
154: fc.closed_ind = 'N';
155: v_fcm_rec c_fcm%ROWTYPE;
156: v_fee_cat IGS_FI_FEE_CAT_MAP.fee_cat%TYPE DEFAULT NULL;
157: BEGIN
158: --get the fee_cat record and check for Multiple Rows
159: FOR v_fcm_rec IN c_fcm LOOP
160: IF c_fcm%ROWCOUNT > 1 THEN