APPS.IGS_FI_PRC_IMPCLC_ANC_CHGS dependencies on IGS_FI_FEE_TYPE

Line 239: FROM igs_fi_fee_type

235: -- Cursor for validating whether the Fee Type is an active fee type
236: -- and the System fee Type is Ancillary
237: CURSOR cur_fee_type(cp_fee_type igs_fi_anc_rates.fee_type%TYPE) IS
238: SELECT 'x'
239: FROM igs_fi_fee_type
240: WHERE fee_type = cp_fee_type
241: AND s_fee_type = g_ancillary
242: AND NVL(closed_ind,'N') = 'N';
243:

Line 442: l_fee_desc igs_fi_fee_type.description%TYPE;

438: l_msg_data VARCHAR2(2000);
439: l_return_status VARCHAR2(1);
440: l_prev_amount igs_fi_inv_int.invoice_amount%TYPE;
441: l_var NUMBER(3);
442: l_fee_desc igs_fi_fee_type.description%TYPE;
443:
444: l_v_local_currency igs_fi_control.currency_cd%TYPE;
445: l_n_curr_cd igs_fi_control.currency_cd%TYPE;
446: l_v_curr_desc fnd_currencies_tl.name%TYPE;

Line 531: CURSOR cur_fee(cp_fee_type IGS_FI_FEE_TYPE.Fee_Type%TYPE) IS

527: AND crt.credit_class = g_v_chgadj
528: AND app.amount_applied = inv.invoice_amount);
529:
530: -- Cursor for fetching the Fee Type description
531: CURSOR cur_fee(cp_fee_type IGS_FI_FEE_TYPE.Fee_Type%TYPE) IS
532: SELECT description
533: FROM igs_fi_fee_type
534: WHERE fee_type = cp_fee_type;
535:

Line 533: FROM igs_fi_fee_type

529:
530: -- Cursor for fetching the Fee Type description
531: CURSOR cur_fee(cp_fee_type IGS_FI_FEE_TYPE.Fee_Type%TYPE) IS
532: SELECT description
533: FROM igs_fi_fee_type
534: WHERE fee_type = cp_fee_type;
535:
536: BEGIN
537: