APPS.AP_CREDIT_CARD_INVOICE_PKG dependencies on AP_SUPPLIER_SITES

Line 51: l_party_site_id ap_supplier_sites.party_site_id%TYPE;

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.
55: l_ccid AP_WEB_DB_AP_INT_PKG.invLines_distCodeCombID;

Line 275: FROM ap_supplier_sites

271: -- Bug 6838894
272: BEGIN
273: SELECT party_site_id, nvl(l_accts_pay_ccid,accts_pay_code_combination_id), terms_id
274: INTO l_party_site_id, l_accts_pay_ccid, l_terms_id
275: FROM ap_supplier_sites
276: WHERE vendor_site_id = l_vendor_site_id;
277: EXCEPTION
278: WHEN NO_DATA_FOUND THEN
279: l_party_site_id := null;