DBA Data[Home] [Help]

APPS.AP_WITHHOLDING_PKG dependencies on AP_SUPPLIERS

Line 1352: l_remit_to_supplier_name AP_SUPPLIERS.VENDOR_NAME%TYPE;

1348: --bug 7699166
1349: l_remit_party_id NUMBER;
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

Line 1353: l_remit_to_supplier_id AP_SUPPLIERS.VENDOR_ID%TYPE;

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

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

1734:
1735: -- Added if else condition as part of bug 8345877
1736: IF (l_relationship_id <> -1) THEN
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;