APPS.AP_WEB_EXPORT_ER dependencies on AP_SUPPLIER_SITES_ALL

Line 3231: l_payment_priority ap_supplier_sites_all.payment_priority%TYPE;

3227: ------------------------------------------------------------------------
3228: PROCEDURE InsertInvoiceInterface(p_invoice_rec InvoiceInfoRecType,
3229: p_vendor_rec VendorInfoRecType) IS
3230: ------------------------------------------------------------------------
3231: l_payment_priority ap_supplier_sites_all.payment_priority%TYPE;
3232: BEGIN
3233: BEGIN
3234: if (p_vendor_rec.vendor_site_id IS NOT NULL AND p_invoice_rec.source in ('Both Pay', 'CREDIT CARD')) then
3235: select payment_priority

Line 3237: from ap_supplier_sites_all

3233: BEGIN
3234: if (p_vendor_rec.vendor_site_id IS NOT NULL AND p_invoice_rec.source in ('Both Pay', 'CREDIT CARD')) then
3235: select payment_priority
3236: into l_payment_priority
3237: from ap_supplier_sites_all
3238: where vendor_site_id = p_vendor_rec.vendor_site_id;
3239: else
3240: l_payment_priority := NULL;
3241: end if;

Line 3885: l_site_allow_awt_flag ap_supplier_sites.allow_awt_flag%TYPE;

3881: l_site_pay_group ap_supplier_sites.pay_group_lookup_code%TYPE;
3882: l_site_terms_date_basis ap_supplier_sites.terms_date_basis%TYPE;
3883: l_site_liab_acc ap_supplier_sites.accts_pay_code_combination_id%TYPE;
3884: l_site_terms_id ap_supplier_sites.terms_id%TYPE;
3885: l_site_allow_awt_flag ap_supplier_sites.allow_awt_flag%TYPE;
3886: l_debug_info VARCHAR2(2000);
3887: l_duplicate_vendor VARCHAR2(2);
3888: l_val_return_status VARCHAR2(50);
3889: l_val_msg_count NUMBER;