APPS.IGS_FI_PRC_REFUNDS dependencies on IGS_FI_FEE_TYPE

Line 65: fee_type IGS_FI_FEE_TYPE.Fee_Type%TYPE,

61: -- PL/SQL record for the Credit Information
62: TYPE crdrec IS RECORD(credit_id IGS_FI_CREDITS.Credit_Id%TYPE,
63: credit_class IGS_FI_CR_TYPES.Credit_Class%TYPE,
64: unapplied_amount IGS_FI_CREDITS.Unapplied_Amount%TYPE,
65: fee_type IGS_FI_FEE_TYPE.Fee_Type%TYPE,
66: fee_cal_type IGS_CA_INST.Cal_Type%TYPE,
67: fee_ci_sequence_number IGS_CA_INST.Sequence_Number%TYPE,
68: credit_number IGS_FI_CREDITS.Credit_Number%TYPE);
69:

Line 80: TYPE rfndfee IS RECORD(fee_type IGS_FI_FEE_TYPE.Fee_Type%TYPE,

76:
77: l_rfnd_cntr NUMBER(15);
78:
79: -- PL/SQL record for the distinct Sub Account and FTCI combination
80: TYPE rfndfee IS RECORD(fee_type IGS_FI_FEE_TYPE.Fee_Type%TYPE,
81: fee_cal_type IGS_CA_INST.Cal_Type%TYPE,
82: fee_ci_sequence_number IGS_CA_INST.Sequence_Number%TYPE);
83:
84: -- PL/SQL table for storing the distinct fee periods to be refunded

Line 281: l_fee_type igs_fi_fee_type.fee_type%TYPE;

277: WHERE credit_type_id = cp_credit_type_id
278: AND cp_effective_date BETWEEN effective_start_date AND NVL(effective_end_date,cp_effective_date);
279:
280: -- Variables of data type as the column of a table
281: l_fee_type igs_fi_fee_type.fee_type%TYPE;
282: l_fee_cal_type igs_ca_inst.cal_type%TYPE;
283: l_fee_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
284: l_dr_gl_ccid igs_fi_refunds.dr_gl_ccid%TYPE;
285: l_cr_gl_ccid igs_fi_refunds.cr_gl_ccid%TYPE;

Line 794: l_fee_type igs_fi_fee_type.fee_type%TYPE;

790: l_payee_id igs_fi_parties_v.person_id%TYPE;
791: l_reason fnd_new_messages.message_text%TYPE;
792: l_err_msg fnd_new_messages.message_name%TYPE;
793: l_determination igs_lookups_view.lookup_code%TYPE;
794: l_fee_type igs_fi_fee_type.fee_type%TYPE;
795: l_fee_cal_type igs_ca_inst.cal_type%TYPE;
796: l_fee_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
797: l_rfnd_amnt igs_fi_refunds.refund_amount%TYPE;
798: l_party_number igs_fi_parties_v.person_number%TYPE;