APPS.IGS_FI_LOAD_EXT_CHG dependencies on IGS_FI_FEE_TYPE

Line 119: FROM igs_fi_fee_type

115:
116: CURSOR c_fee_typ
117: IS
118: SELECT 'x'
119: FROM igs_fi_fee_type
120: WHERE s_fee_type = 'EXTERNAL'
121: AND fee_type = p_fee_type
122: AND NVL(closed_ind,'N') = 'N';
123:

Line 423: CURSOR cur_fee_desc(cp_fee_type igs_fi_fee_type.fee_type%TYPE) IS

419: l_n_err_type NUMBER;
420: l_v_err_string igs_fi_invln_int.error_string%TYPE;
421: l_b_return_status BOOLEAN;
422:
423: CURSOR cur_fee_desc(cp_fee_type igs_fi_fee_type.fee_type%TYPE) IS
424: SELECT description
425: FROM igs_fi_fee_type
426: WHERE fee_type = cp_fee_type;
427:

Line 425: FROM igs_fi_fee_type

421: l_b_return_status BOOLEAN;
422:
423: CURSOR cur_fee_desc(cp_fee_type igs_fi_fee_type.fee_type%TYPE) IS
424: SELECT description
425: FROM igs_fi_fee_type
426: WHERE fee_type = cp_fee_type;
427:
428: l_n_record_count PLS_INTEGER :=0;
429: l_b_flag BOOLEAN := TRUE;