APPS.IGS_FI_WAV_UTILS_002 dependencies on IGS_FI_INV_INT_ALL

Line 44: p_n_waiver_amt IN igs_fi_inv_int_all.invoice_amount%TYPE,

40: p_n_fee_ci_seq_number IN igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE,
41: p_v_waiver_name IN igs_fi_waiver_pgms.waiver_name%TYPE,
42: p_v_adj_fee_type IN igs_fi_fee_type.fee_type%TYPE,
43: p_v_currency_cd IN igs_fi_control.currency_cd%TYPE,
44: p_n_waiver_amt IN igs_fi_inv_int_all.invoice_amount%TYPE,
45: p_d_gl_date IN igs_fi_invln_int.gl_date%TYPE,
46: p_n_invoice_id OUT NOCOPY igs_fi_inv_int.invoice_id%TYPE,
47: x_return_status OUT NOCOPY VARCHAR2) AS
48: /******************************************************************

Line 455: igs_fi_inv_int_all inv

451: appl.application_id,
452: appl.credit_id,
453: appl.invoice_id
454: FROM igs_fi_applications appl,
455: igs_fi_inv_int_all inv
456: WHERE appl.credit_id = cp_n_source_credit_id
457: AND appl.invoice_id = inv.invoice_id
458: AND appl.application_type = 'APP'
459: AND inv.transaction_type <> 'WAIVER_ADJ'

Line 499: l_n_inv_amt_due igs_fi_inv_int_all.invoice_amount_due%TYPE;

495: l_n_cr_gl_ccid igs_fi_cr_activities.cr_gl_ccid%TYPE;
496: l_v_dr_account_cd igs_fi_cr_activities.dr_account_cd%TYPE;
497: l_v_cr_account_cd igs_fi_cr_activities.cr_account_cd%TYPE;
498: l_n_unapp_amount igs_fi_credits_all.unapplied_amount%TYPE;
499: l_n_inv_amt_due igs_fi_inv_int_all.invoice_amount_due%TYPE;
500: l_v_err_msg fnd_new_messages.message_name%TYPE;
501: l_b_status BOOLEAN;
502: l_n_wav_adj_amount NUMBER;
503: l_n_unapplied_amount NUMBER;

Line 783: igs_fi_inv_int_all inv

779: appl.application_id,
780: appl.credit_id,
781: appl.invoice_id
782: FROM igs_fi_applications appl,
783: igs_fi_inv_int_all inv
784: WHERE appl.credit_id = cp_n_source_credit_id
785: AND appl.invoice_id = inv.invoice_id
786: AND appl.application_type = 'APP'
787: AND inv.transaction_type <> 'WAIVER_ADJ'