DBA Data[Home] [Help]

APPS.PON_AUCTION_CREATE_PO_PKG dependencies on PO_VENDOR_CONTACTS

Line 6233: FROM po_vendor_contacts

6229: l_vendor_contact_id NUMBER := NULL;
6230: BEGIN
6231: SELECT
6232: vendor_contact_id into l_vendor_contact_id
6233: FROM po_vendor_contacts
6234: WHERE per_party_id = p_trading_partner_contact_id
6235: AND vendor_site_id = p_vendor_site_id
6236: AND vendor_id = p_vendor_id
6237: AND INACTIVE_DATE > sysdate;