DBA Data[Home] [Help]

APPS.AP_WITHHOLDING_PKG dependencies on AP_SUPPLIER_SITES

Line 758: l_remit_to_supplier_site AP_SUPPLIER_SITES.VENDOR_SITE_CODE%TYPE;

754: l_relationship_id NUMBER;
755: l_invoice_date DATE;
756: l_remit_to_supplier_name AP_SUPPLIERS.VENDOR_NAME%TYPE;
757: l_remit_to_supplier_id AP_SUPPLIERS.VENDOR_ID%TYPE;
758: l_remit_to_supplier_site AP_SUPPLIER_SITES.VENDOR_SITE_CODE%TYPE;
759: l_remit_to_supplier_site_id AP_SUPPLIER_SITES.VENDOR_SITE_ID%TYPE;
760: l_remit_to_party_site_id AP_SUPPLIER_SITES.PARTY_SITE_ID%TYPE; --7721149
761: --bug 7699166
762:

Line 759: l_remit_to_supplier_site_id AP_SUPPLIER_SITES.VENDOR_SITE_ID%TYPE;

755: l_invoice_date DATE;
756: l_remit_to_supplier_name AP_SUPPLIERS.VENDOR_NAME%TYPE;
757: l_remit_to_supplier_id AP_SUPPLIERS.VENDOR_ID%TYPE;
758: l_remit_to_supplier_site AP_SUPPLIER_SITES.VENDOR_SITE_CODE%TYPE;
759: l_remit_to_supplier_site_id AP_SUPPLIER_SITES.VENDOR_SITE_ID%TYPE;
760: l_remit_to_party_site_id AP_SUPPLIER_SITES.PARTY_SITE_ID%TYPE; --7721149
761: --bug 7699166
762:
763: --

Line 760: l_remit_to_party_site_id AP_SUPPLIER_SITES.PARTY_SITE_ID%TYPE; --7721149

756: l_remit_to_supplier_name AP_SUPPLIERS.VENDOR_NAME%TYPE;
757: l_remit_to_supplier_id AP_SUPPLIERS.VENDOR_ID%TYPE;
758: l_remit_to_supplier_site AP_SUPPLIER_SITES.VENDOR_SITE_CODE%TYPE;
759: l_remit_to_supplier_site_id AP_SUPPLIER_SITES.VENDOR_SITE_ID%TYPE;
760: l_remit_to_party_site_id AP_SUPPLIER_SITES.PARTY_SITE_ID%TYPE; --7721149
761: --bug 7699166
762:
763: --
764: CURSOR c_awt_lines (InvId IN NUMBER) IS

Line 927: l_remit_to_supplier_site from ap_supplier_sites where vendor_site_id = l_remit_to_supplier_site_id

923: select vendor_id, vendor_name into l_remit_to_supplier_id, l_remit_to_supplier_name
924: from ap_suppliers where party_id = l_remit_party_id and rownum<2;
925:
926: select party_site_id, vendor_site_code into l_remit_to_party_site_id,
927: l_remit_to_supplier_site from ap_supplier_sites where vendor_site_id = l_remit_to_supplier_site_id
928: and rownum<2;
929: -- retrieving party_site_id also as part of bug 7721149
930:
931: --bug 7699166