DBA Data[Home] [Help]

APPS.IGI_CIS2007_IGIPMTHR_PKG dependencies on AP_INVOICE_PAYMENTS

Line 45: payment_id ap_invoice_payments.invoice_payment_id%type,

41: TYPE payment_details_rec IS RECORD (
42: child_id AP_SUPPLIERS.vendor_id%type,
43: parent_id AP_SUPPLIERS.parent_vendor_id%type,
44: invoice_id ap_invoices.invoice_id%type,
45: payment_id ap_invoice_payments.invoice_payment_id%type,
46: invoice_payment_amount ap_invoice_payments.amount%type,
47: discount_amount ap_invoice_payments.discount_taken%type);
48:
49: TYPE all_payments IS TABLE OF payment_details_rec INDEX BY BINARY_INTEGER;

Line 46: invoice_payment_amount ap_invoice_payments.amount%type,

42: child_id AP_SUPPLIERS.vendor_id%type,
43: parent_id AP_SUPPLIERS.parent_vendor_id%type,
44: invoice_id ap_invoices.invoice_id%type,
45: payment_id ap_invoice_payments.invoice_payment_id%type,
46: invoice_payment_amount ap_invoice_payments.amount%type,
47: discount_amount ap_invoice_payments.discount_taken%type);
48:
49: TYPE all_payments IS TABLE OF payment_details_rec INDEX BY BINARY_INTEGER;
50: all_payment_list all_payments;

Line 47: discount_amount ap_invoice_payments.discount_taken%type);

43: parent_id AP_SUPPLIERS.parent_vendor_id%type,
44: invoice_id ap_invoices.invoice_id%type,
45: payment_id ap_invoice_payments.invoice_payment_id%type,
46: invoice_payment_amount ap_invoice_payments.amount%type,
47: discount_amount ap_invoice_payments.discount_taken%type);
48:
49: TYPE all_payments IS TABLE OF payment_details_rec INDEX BY BINARY_INTEGER;
50: all_payment_list all_payments;
51:

Line 62: ap_invoice_payments aipa,

58: aipa.invoice_payment_id payment_id,
59: aipa.amount invoice_payment_amount,
60: aipa.discount_taken discount_amount
61: FROM ap_invoices aia,
62: ap_invoice_payments aipa,
63: ap_checks aca,
64: AP_SUPPLIERS pov,
65: AP_SUPPLIERS pov1,
66: -- Bug 5647413 Start