[Home] [Help]
132: -- only when the balance type is FEE. For Holds, waived charges are considered in Process that apply/release holds.
133: --schodava 06-Oct-2003 Bug # 3123405 - Modified cursors cur_chrgs_for_balance and cur_crds_for_balance.
134: -- Also modified logic, to use the invoice_amount and credit amount, instead of
135: -- invoice_amount_due and unapplied_amount respectively.
136: --vvutukur 10-DEC-2002 Enh# 2584741 - Modified cursor cur_crds_for_balance - added join with igs_fi_cr_types
137: -- to exclude deposit records while obtaining records for balances calculation
138: --vvutukur 04-Oct-2002 Enh#2562745.Removed references to balance types 'Installment','Other'
139: -- as the same have become obsolete.Renamed this local function calculate_balance_1
140: -- to a public procedure calculate_balance.Modified charges and credits cursors
204: CURSOR cur_crds_for_balance IS
205: SELECT cra.*
206: FROM igs_fi_credits crd,
207: igs_fi_cr_activities cra,
208: igs_fi_cr_types cty
209: WHERE party_id = p_person_id
210: AND crd.credit_id = cra.credit_id
211: AND cty.credit_type_id = crd.credit_type_id
212: AND cty.credit_class NOT IN ('ENRDEPOSIT','OTHDEPOSIT')
943: FROM IGS_FI_BAL_EX_F_TYPS_V
944: WHERE fee_type = cp_fee_type
945: AND balance_rule_id = cp_balance_rule_id;
946:
947: CURSOR c_ctyp_excl(cp_credit_type_id igs_fi_cr_types.credit_type_id%TYPE,
948: cp_balance_rule_id igs_fi_balance_rules.balance_rule_id%TYPE
949: )IS
950: SELECT 'X'
951: FROM IGS_FI_BAL_EX_C_TYPS_V