DBA Data[Home] [Help]

APPS.AP_VENDOR_PUB_PKG dependencies on PO_VENDOR_CONTACTS

Line 11919: SELECT po_vendor_contacts_s.nextval

11915: (l_email_return_status = FND_API.G_RET_STS_SUCCESS) AND
11916: (l_url_return_status = FND_API.G_RET_STS_SUCCESS) THEN
11917:
11918:
11919: SELECT po_vendor_contacts_s.nextval
11920: INTO l_vendor_contact_rec.vendor_contact_id
11921: FROM dual;
11922:
11923: INSERT INTO ap_supplier_contacts(

Line 14369: FROM po_vendor_contacts

14365:
14366: IF i_vendor_contact_id IS NOT NULL THEN
14367: SELECT vendor_id
14368: INTO l_vendor_id
14369: FROM po_vendor_contacts
14370: WHERE vendor_contact_id = i_vendor_contact_id
14371: AND ROWNUM = 1;
14372: END IF;
14373: ELSE