APPS.AP_CREDIT_CARD_INVOICE_PKG dependencies on AP_SUPPLIERS

Line 50: l_party_id ap_suppliers.party_id%TYPE;

46: l_transaction_date DATE; --3028505, renamed this variable
47: l_invoice_id AP_WEB_DB_AP_INT_PKG.invLines_invID;
48: l_invoice_id_temp AP_WEB_DB_AP_INT_PKG.invLines_invID; -- Bug 6687752
49: l_invoice_line_id AP_WEB_DB_AP_INT_PKG.invLines_invLineID;
50: l_party_id ap_suppliers.party_id%TYPE;
51: l_party_site_id ap_supplier_sites.party_site_id%TYPE;
52: l_vendor_id AP_WEB_DB_CCARD_PKG.cardProgs_vendorID;
53: l_vendor_site_id AP_WEB_DB_CCARD_PKG.cardProgs_vendorSiteID;
54: l_terms_id AP_TERMS.TERM_ID%TYPE; -- Bug: 7234744 populate terms-id in the interface table.

Line 253: from ap_suppliers

249: l_debugInfo := 'Retrieving Party Id using Vendor Id';
250: -----------------------------------------------------------------------
251: select party_id
252: into l_party_id
253: from ap_suppliers
254: where vendor_id = l_vendor_id
255: and rownum = 1;
256:
257: -----------------------------------------------------------------------

Line 291: FROM ap_suppliers

287: IF (l_terms_id IS NULL) THEN
288: BEGIN
289: SELECT terms_id
290: INTO l_terms_id
291: FROM ap_suppliers
292: WHERE vendor_id = l_vendor_id;
293: EXCEPTION
294: WHEN OTHERS THEN
295: l_terms_id := null;