APPS.AHL_OSP_ORDERS_PVT dependencies on PO_VENDOR_CONTACTS

Line 6299: FROM po_vendor_contacts

6295: AND TRUNC(active_start_date) <= TRUNC(SYSDATE)
6296: AND TRUNC(nvl(active_end_date, SYSDATE+1)) > TRUNC(SYSDATE);
6297: CURSOR val_vendor_contact_id_csr IS
6298: SELECT 'X'
6299: FROM po_vendor_contacts
6300: WHERE vendor_site_id = p_vendor_site_id
6301: AND vendor_contact_id = p_vendor_contact_id
6302: AND TRUNC(NVL(inactive_date, SYSDATE+1)) > TRUNC(SYSDATE);
6303: CURSOR get_contact_cert IS