DBA Data[Home] [Help]

APPS.IGI_CIS2007_IGIPMTHR_PKG dependencies on AP_INVOICE_PAYMENTS

Line 80: payment_id ap_invoice_payments.invoice_payment_id%type,

76: TYPE payment_details_rec IS RECORD (
77: child_id AP_SUPPLIERS.vendor_id%type,
78: parent_id AP_SUPPLIERS.parent_vendor_id%type,
79: invoice_id ap_invoices.invoice_id%type,
80: payment_id ap_invoice_payments.invoice_payment_id%type,
81: invoice_payment_amount ap_invoice_payments.amount%type,
82: discount_amount ap_invoice_payments.discount_taken%type);
83:
84: TYPE all_payments IS TABLE OF payment_details_rec INDEX BY BINARY_INTEGER;

Line 81: invoice_payment_amount ap_invoice_payments.amount%type,

77: child_id AP_SUPPLIERS.vendor_id%type,
78: parent_id AP_SUPPLIERS.parent_vendor_id%type,
79: invoice_id ap_invoices.invoice_id%type,
80: payment_id ap_invoice_payments.invoice_payment_id%type,
81: invoice_payment_amount ap_invoice_payments.amount%type,
82: discount_amount ap_invoice_payments.discount_taken%type);
83:
84: TYPE all_payments IS TABLE OF payment_details_rec INDEX BY BINARY_INTEGER;
85: all_payment_list all_payments;

Line 82: discount_amount ap_invoice_payments.discount_taken%type);

78: parent_id AP_SUPPLIERS.parent_vendor_id%type,
79: invoice_id ap_invoices.invoice_id%type,
80: payment_id ap_invoice_payments.invoice_payment_id%type,
81: invoice_payment_amount ap_invoice_payments.amount%type,
82: discount_amount ap_invoice_payments.discount_taken%type);
83:
84: TYPE all_payments IS TABLE OF payment_details_rec INDEX BY BINARY_INTEGER;
85: all_payment_list all_payments;
86:

Line 98: ap_invoice_payments aipa,

94: aipa.invoice_payment_id payment_id,
95: aipa.amount invoice_payment_amount,
96: aipa.discount_taken discount_amount
97: FROM ap_invoices aia,
98: ap_invoice_payments aipa,
99: ap_checks aca,
100: AP_SUPPLIERS pov,
101: AP_SUPPLIERS pov1,
102: -- Bug 5647413 Start