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 278: FROM ap_supplier_sites

274: BEGIN
275: SELECT party_site_id,
276: nvl(accts_pay_code_combination_id,(select accts_pay_code_combination_id from ap_system_parameters)), terms_id
277: INTO l_party_site_id, l_accts_pay_ccid, l_terms_id
278: FROM ap_supplier_sites
279: WHERE vendor_site_id = l_vendor_site_id;
280: EXCEPTION
281: WHEN NO_DATA_FOUND THEN
282: l_party_site_id := null;