APPS.IGS_FI_PRC_BALANCES dependencies on IGS_FI_INV_INT_V

Line 228: l_rowid igs_fi_inv_int_v.row_id%TYPE;

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;
231: l_bal_fee igs_fi_balances.standard_balance%TYPE := 0.0;
232: l_bal_hold igs_fi_balances.standard_balance%TYPE := 0.0;

Line 908: l_fee_type igs_fi_inv_int_v.fee_type%TYPE;

904: -- smadathi 10-APR-2002 Bug 2289191. References to enabled_flag column removed from cursor
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);

Line 929: FROM igs_fi_inv_int_v

925: --removed cursor c_balance.
926:
927: CURSOR c_charge(cp_source_id igs_fi_inv_int.invoice_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