DBA Data[Home] [Help]

APPS.IGS_FI_PRC_REFUNDS dependencies on IGS_FI_INV_INT

Line 290: l_invoice_id igs_fi_inv_int.invoice_id%TYPE;

286: l_dr_account_cd igs_fi_refunds.dr_account_cd%TYPE;
287: l_cr_account_cd igs_fi_refunds.cr_account_cd%TYPE;
288: l_rowid igs_fi_refunds_v.row_id%TYPE;
289: l_refund_id igs_fi_refunds.refund_id%TYPE;
290: l_invoice_id igs_fi_inv_int.invoice_id%TYPE;
291: l_dr_ccid igs_fi_refunds.dr_gl_ccid%TYPE;
292: l_cr_ccid igs_fi_refunds.cr_gl_ccid%TYPE;
293: l_dr_acc_cd igs_fi_refunds.dr_account_cd%TYPE;
294: l_cr_acc_cd igs_fi_refunds.cr_account_cd%TYPE;

Line 295: l_inv_amt_due igs_fi_inv_int.invoice_amount_due%TYPE;

291: l_dr_ccid igs_fi_refunds.dr_gl_ccid%TYPE;
292: l_cr_ccid igs_fi_refunds.cr_gl_ccid%TYPE;
293: l_dr_acc_cd igs_fi_refunds.dr_account_cd%TYPE;
294: l_cr_acc_cd igs_fi_refunds.cr_account_cd%TYPE;
295: l_inv_amt_due igs_fi_inv_int.invoice_amount_due%TYPE;
296: l_unapp_amount igs_fi_credits.unapplied_amount%TYPE;
297: l_application_id igs_fi_applications.application_id%TYPE;
298: l_payee_id igs_fi_parties_v.person_id%TYPE;
299: l_reason fnd_new_messages.message_text%TYPE;

Line 771: FROM igs_fi_inv_int

767:
768: -- Cursor for getting the Invoice Number based on the Invoice Id
769: CURSOR cur_inv(cp_invoice_id NUMBER) IS
770: SELECT invoice_number
771: FROM igs_fi_inv_int
772: WHERE invoice_id = cp_invoice_id;
773:
774:
775: -- Variables of the database column type

Line 782: l_invoice_id igs_fi_inv_int.invoice_id%TYPE;

778: l_dr_account_cd igs_fi_refunds.dr_account_cd%TYPE;
779: l_cr_account_cd igs_fi_refunds.cr_account_cd%TYPE;
780: l_rowid igs_fi_refunds_v.row_id%TYPE;
781: l_refund_id igs_fi_refunds.refund_id%TYPE;
782: l_invoice_id igs_fi_inv_int.invoice_id%TYPE;
783: l_dr_ccid igs_fi_refunds.dr_gl_ccid%TYPE;
784: l_cr_ccid igs_fi_refunds.cr_gl_ccid%TYPE;
785: l_dr_acc_cd igs_fi_refunds.dr_account_cd%TYPE;
786: l_cr_acc_cd igs_fi_refunds.cr_account_cd%TYPE;

Line 787: l_inv_amt_due igs_fi_inv_int.invoice_amount_due%TYPE;

783: l_dr_ccid igs_fi_refunds.dr_gl_ccid%TYPE;
784: l_cr_ccid igs_fi_refunds.cr_gl_ccid%TYPE;
785: l_dr_acc_cd igs_fi_refunds.dr_account_cd%TYPE;
786: l_cr_acc_cd igs_fi_refunds.cr_account_cd%TYPE;
787: l_inv_amt_due igs_fi_inv_int.invoice_amount_due%TYPE;
788: l_unapp_amount igs_fi_credits.unapplied_amount%TYPE;
789: l_application_id igs_fi_applications.application_id%TYPE;
790: l_payee_id igs_fi_parties_v.person_id%TYPE;
791: l_reason fnd_new_messages.message_text%TYPE;

Line 799: l_invoice_number igs_fi_inv_int.invoice_number%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;
799: l_invoice_number igs_fi_inv_int.invoice_number%TYPE;
800: l_group_cd igs_pe_all_persid_group_v.group_cd%TYPE;
801: l_v_message_name fnd_new_messages.message_name%TYPE;
802: l_v_closing_status gl_period_statuses.closing_status%TYPE;
803: l_d_gl_date igs_fi_credits_all.gl_date%TYPE;