APPS.IGS_FI_PRC_BALANCES dependencies on IGS_FI_CREDITS

Line 206: FROM igs_fi_credits crd,

202:
203: -- cursor reads from credits table
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

Line 226: l_credit_amount igs_fi_credits_all.amount%TYPE := 0.0;

222: AND TRUNC(balance_date) = TRUNC(p_balance_date);
223:
224: l_cur_rec_exists cur_rec_exists%ROWTYPE;
225: l_invoice_amount igs_fi_balances.standard_balance%TYPE := 0.0;
226: l_credit_amount igs_fi_credits_all.amount%TYPE := 0.0;
227: l_balance igs_fi_balances.standard_balance%TYPE := 0.0;
228: l_rowid igs_fi_inv_int_v.row_id%TYPE;
229: l_balance_id igs_fi_balances.balance_id%TYPE;
230: l_bal_standard igs_fi_balances.standard_balance%TYPE := 0.0;

Line 897: -- sapanigr 14-Feb_2006 Bug 5018036. Cursor c_credit now uses igs_fi_credits_all instead of igs_fi_credits

893: -- the exclusion rules set up for a particular balance type before
894: -- arriving at the final balances.
895: -- Change History
896: -- Who When What
897: -- sapanigr 14-Feb_2006 Bug 5018036. Cursor c_credit now uses igs_fi_credits_all instead of igs_fi_credits
898: -- vvutukur 04-Oct-2002 Enh#2562745.Added a new mandatory parametre p_balance_rule_id.Removed
899: -- cursor c_balance and its usage in the code.Modified cursor c_bal_type
900: -- as 'INSTALLMENT','OTHER' balance types have been obsoleted.
901: -- smvk 17-Sep-2002 Removed the references to subaccount_id, as a part of Bug # 2564643

Line 909: l_credit_type_id igs_fi_credits_v.credit_type_id%TYPE;

905: -- c_subacct_excl, c_ftype_excl, c_ctyp_excl select list.
906: -- (reverse chronological order - newest change first)
907: -------------------------------------------------------------------------------
908: l_fee_type igs_fi_inv_int_v.fee_type%TYPE;
909: l_credit_type_id igs_fi_credits_v.credit_type_id%TYPE;
910: l_balance_rule_id igs_fi_balance_rules.balance_rule_id%TYPE := p_balance_rule_id;
911: l_std_bal igs_lookup_values.lookup_code%TYPE := 'STANDARD';
912: l_sysdate DATE := TRUNC(SYSDATE);
913: l_lkp_type igs_lookup_values.lookup_type%TYPE := 'IGS_FI_BALANCE_TYPE';

Line 932: CURSOR c_credit(cp_source_id igs_fi_credits_all.credit_id%TYPE)IS

928: SELECT fee_type, invoice_creation_date
929: FROM igs_fi_inv_int_v
930: WHERE invoice_id = cp_source_id;
931:
932: CURSOR c_credit(cp_source_id igs_fi_credits_all.credit_id%TYPE)IS
933: SELECT credit_type_id, effective_date
934: FROM igs_fi_credits_all
935: WHERE credit_id = cp_source_id;
936:

Line 934: FROM igs_fi_credits_all

930: WHERE invoice_id = cp_source_id;
931:
932: CURSOR c_credit(cp_source_id igs_fi_credits_all.credit_id%TYPE)IS
933: SELECT credit_type_id, effective_date
934: FROM igs_fi_credits_all
935: WHERE credit_id = cp_source_id;
936:
937: /* Removed the cursor c_subacct_excl, as a part of Bug # 2564643 */
938: