APPS.PO_VAL_HEADERS2 dependencies on PO_VENDOR_CONTACTS

Line 695: -- validate vendor_contact_id using po_vendor_contacts

691: -- validate vendorId is Not Null
692: -- validate vendorSiteId is Not Null
693: -- validate vendor_id using po_suppliers_val_v
694: -- validate vendor_site_id using po_supplier_sites_val_v
695: -- validate vendor_contact_id using po_vendor_contacts
696: -- validate vendor site CCR if approval status is APPROVED.
697: -------------------------------------------------------------------------
698: PROCEDURE vendor_info(
699: p_id_tbl IN po_tbl_number,

Line 844: FROM po_vendor_contacts pvc

840: WHERE p_vendor_id_tbl(i) IS NOT NULL
841: AND p_vendor_site_id_tbl(i) IS NOT NULL
842: AND p_vendor_contact_id_tbl(i) IS NOT NULL
843: AND NOT EXISTS(SELECT 1
844: FROM po_vendor_contacts pvc
845: WHERE p_vendor_site_id_tbl(i) = pvc.vendor_site_id
846: AND p_vendor_contact_id_tbl(i) = pvc.vendor_contact_id);
847:
848: IF (SQL%ROWCOUNT > 0) THEN