APPS.AP_INTEREST_INVOICE_PKG dependencies on AP_INVOICES_ALL

Line 806: FROM AP_INVOICES_ALL

802: relationship_id
803: INTO l_remit_to_supplier_name, l_remit_to_supplier_id,
804: l_remit_to_supplier_site, l_remit_to_supplier_site_id,
805: l_relationship_id
806: FROM AP_INVOICES_ALL
807: WHERE INVOICE_ID = P_Invoice_id;
808:
809: debug_info := 'Insert into ap_invoices';
810:

Line 1933: UPDATE ap_invoices_all AI

1929: l_Debug_Info := 'Zero related invoice';
1930:
1931: --Bug 4539462 DBI logging
1932: --Bug 5056061 Modified the update to prevent FTS
1933: UPDATE ap_invoices_all AI
1934: SET AI.description='VOID '||AI.description,
1935: AI.invoice_amount = 0,
1936: AI.pay_curr_invoice_amount = 0,
1937: AI.amount_paid = 0,

Line 2206: ap_invoices_all ai

2202:
2203: SELECT nvl(interest_tolerance_amount,0)
2204: INTO C_interest_tolerance_amount
2205: FROM ap_system_parameters_all asp,
2206: ap_invoices_all ai
2207: WHERE ai.org_id = asp.org_id
2208: AND ai.invoice_id = p_invoice_id;
2209:
2210: ----------------------------------------------------------

Line 2691: ap_invoices_all orig,

2687: orig.invoice_id P_invoice_id,
2688: orig.invoice_currency_code P_invoice_currency_code,
2689: orig.org_id P_org_id
2690: FROM po_vendors pv,
2691: ap_invoices_all orig,
2692: ap_selected_invoices_all new,
2693: fnd_currencies base,
2694: fnd_currencies fcinv,
2695: iby_fd_docs_payable_v ibydocs