APPS.AP_WITHHOLDING_PKG dependencies on AP_SUPPLIER_SITES

Line 1354: l_remit_to_supplier_site AP_SUPPLIER_SITES.VENDOR_SITE_CODE%TYPE;

1350: l_relationship_id NUMBER;
1351: l_invoice_date DATE;
1352: l_remit_to_supplier_name AP_SUPPLIERS.VENDOR_NAME%TYPE;
1353: l_remit_to_supplier_id AP_SUPPLIERS.VENDOR_ID%TYPE;
1354: l_remit_to_supplier_site AP_SUPPLIER_SITES.VENDOR_SITE_CODE%TYPE;
1355: l_remit_to_supplier_site_id AP_SUPPLIER_SITES.VENDOR_SITE_ID%TYPE;
1356: l_remit_to_party_site_id AP_SUPPLIER_SITES.PARTY_SITE_ID%TYPE; --7721149
1357: --bug 7699166
1358:

Line 1355: l_remit_to_supplier_site_id AP_SUPPLIER_SITES.VENDOR_SITE_ID%TYPE;

1351: l_invoice_date DATE;
1352: l_remit_to_supplier_name AP_SUPPLIERS.VENDOR_NAME%TYPE;
1353: l_remit_to_supplier_id AP_SUPPLIERS.VENDOR_ID%TYPE;
1354: l_remit_to_supplier_site AP_SUPPLIER_SITES.VENDOR_SITE_CODE%TYPE;
1355: l_remit_to_supplier_site_id AP_SUPPLIER_SITES.VENDOR_SITE_ID%TYPE;
1356: l_remit_to_party_site_id AP_SUPPLIER_SITES.PARTY_SITE_ID%TYPE; --7721149
1357: --bug 7699166
1358:
1359: --

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

1352: l_remit_to_supplier_name AP_SUPPLIERS.VENDOR_NAME%TYPE;
1353: l_remit_to_supplier_id AP_SUPPLIERS.VENDOR_ID%TYPE;
1354: l_remit_to_supplier_site AP_SUPPLIER_SITES.VENDOR_SITE_CODE%TYPE;
1355: l_remit_to_supplier_site_id AP_SUPPLIER_SITES.VENDOR_SITE_ID%TYPE;
1356: l_remit_to_party_site_id AP_SUPPLIER_SITES.PARTY_SITE_ID%TYPE; --7721149
1357: --bug 7699166
1358:
1359: --
1360: --8266021 changed cursor --

Line 1741: l_remit_to_supplier_site from ap_supplier_sites where vendor_site_id = l_remit_to_supplier_site_id

1737: select vendor_id, vendor_name into l_remit_to_supplier_id, l_remit_to_supplier_name
1738: from ap_suppliers where party_id = l_remit_party_id and rownum<2;
1739:
1740: select party_site_id, vendor_site_code into l_remit_to_party_site_id,
1741: l_remit_to_supplier_site from ap_supplier_sites where vendor_site_id = l_remit_to_supplier_site_id
1742: and rownum<2;
1743: ELSE
1744: l_remit_party_id := null;
1745: l_remit_to_party_site_id := null;