APPS.AP_INVOICES_POST_PROCESS_PKG dependencies on AP_INVOICE_DISTRIBUTIONS

Line 155: -- and AP_INVOICE_DISTRIBUTIONS

151:
152: -----------------------------------------------------------------------
153: -- Procedure insert_children
154: -- Inserts child records into AP_HOLDS, AP_PAYMENT_SCHEDULES,
155: -- and AP_INVOICE_DISTRIBUTIONS
156: -- PRECONDITION: Called from PRE-UPDATE, POST-INSERT of INV_SUM_FOLDER
157: -----------------------------------------------------------------------
158: procedure insert_children (
159: X_invoice_id IN NUMBER,

Line 622: FROM ap_invoice_distributions

618: -- bug 2663549 amount_remaining should be adjusted for AWT amount
619: -- after payment_schedule has been recreated.
620: SELECT sum( nvl(amount, 0) )
621: INTO l_awt_amount
622: FROM ap_invoice_distributions
623: WHERE invoice_id = X_invoice_id
624: AND line_type_lookup_code = 'AWT';
625:
626: SELECT sum(nvl(amount_remaining,0)), sum(nvl(gross_amount,0))

Line 767: ap_invoice_distributions_pkg.update_distributions

763: --
764: if (nvl(X_update_base,'N') = 'Y' or
765: nvl(X_reset_match_status,'N') = 'Y') then
766:
767: ap_invoice_distributions_pkg.update_distributions
768: (X_invoice_id,
769: X_line_number,
770: X_type_1099,
771: X_income_tax_region,