APPS.AHL_OSP_ORDERS_PVT dependencies on PO_VENDOR_CONTACTS

Line 6748: FROM po_vendor_contacts

6744: AND TRUNC(active_start_date) <= TRUNC(SYSDATE)
6745: AND TRUNC(nvl(active_end_date, SYSDATE+1)) > TRUNC(SYSDATE);
6746: CURSOR val_vendor_contact_id_csr IS
6747: SELECT 'X'
6748: FROM po_vendor_contacts
6749: WHERE vendor_site_id = p_vendor_site_id
6750: AND vendor_contact_id = p_vendor_contact_id
6751: AND TRUNC(NVL(inactive_date, SYSDATE+1)) > TRUNC(SYSDATE);
6752: CURSOR get_contact_cert IS