APPS.AP_INTEREST_INVOICE_PKG dependencies on AP_INVOICES_ALL

Line 783: l_remit_party_id AP_INVOICES_ALL.party_id%TYPE; -- bug 8557334

779: debug_info VARCHAR2(100);
780: current_calling_sequence VARCHAR2(2000);
781:
782: --Start of 8249618
783: l_remit_party_id AP_INVOICES_ALL.party_id%TYPE; -- bug 8557334
784: l_remit_to_supplier_name AP_INVOICES.remit_to_supplier_name%TYPE;
785: l_remit_to_supplier_id AP_INVOICES.remit_to_supplier_id%TYPE;
786: l_remit_to_supplier_site AP_INVOICES.remit_to_supplier_site%TYPE;
787: l_remit_to_supplier_site_id AP_INVOICES.remit_to_supplier_site_id%TYPE;

Line 814: FROM AP_INVOICES_ALL

810: relationship_id
811: INTO l_remit_to_supplier_name, l_remit_to_supplier_id,
812: l_remit_to_supplier_site, l_remit_to_supplier_site_id,
813: l_relationship_id
814: FROM AP_INVOICES_ALL
815: WHERE INVOICE_ID = P_Invoice_id;*/
816:
817: IBY_EXT_PAYEE_RELSHIPS_PKG.default_Ext_Payee_Relationship (
818: p_party_id => p_party_id,

Line 1807: FROM AP_INVOICES_ALL

1803: relationship_id
1804: INTO l_remit_to_supplier_name, l_remit_to_supplier_id,
1805: l_remit_to_supplier_site, l_remit_to_supplier_site_id,
1806: l_relationship_id
1807: FROM AP_INVOICES_ALL
1808: WHERE INVOICE_ID = P_int_invoice_id;
1809:
1810:
1811: INSERT INTO AP_PAYMENT_SCHEDULES(

Line 2029: UPDATE ap_invoices_all AI

2025: l_Debug_Info := 'Zero related invoice';
2026:
2027: --Bug 4539462 DBI logging
2028: --Bug 5056061 Modified the update to prevent FTS
2029: UPDATE ap_invoices_all AI
2030: SET AI.description='VOID '||AI.description,
2031: AI.invoice_amount = 0,
2032: AI.pay_curr_invoice_amount = 0,
2033: AI.amount_paid = 0,

Line 2302: ap_invoices_all ai

2298:
2299: SELECT nvl(interest_tolerance_amount,0)
2300: INTO C_interest_tolerance_amount
2301: FROM ap_system_parameters_all asp,
2302: ap_invoices_all ai
2303: WHERE ai.org_id = asp.org_id
2304: AND ai.invoice_id = p_invoice_id;
2305:
2306: ----------------------------------------------------------

Line 2809: ap_invoices_all orig,

2805: orig.invoice_id P_invoice_id,
2806: orig.invoice_currency_code P_invoice_currency_code,
2807: orig.org_id P_org_id
2808: FROM po_vendors pv,
2809: ap_invoices_all orig,
2810: ap_selected_invoices_all new,
2811: fnd_currencies base,
2812: fnd_currencies fcinv,
2813: iby_fd_docs_payable_v ibydocs