DBA Data[Home] [Help]

APPS.AP_WITHHOLDING_PKG dependencies on AP_SUPPLIERS

Line 756: l_remit_to_supplier_name AP_SUPPLIERS.VENDOR_NAME%TYPE;

752: --bug 7699166
753: l_remit_party_id NUMBER;
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

Line 757: l_remit_to_supplier_id AP_SUPPLIERS.VENDOR_ID%TYPE;

753: l_remit_party_id NUMBER;
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

Line 924: from ap_suppliers where party_id = l_remit_party_id and rownum<2;

920: );
921:
922:
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;