APPS.AHL_OSP_SHIPMENT_PUB dependencies on OE_CONTACTS_V

Line 1592: FROM OE_CONTACTS_V

1588: AND name = p_name;
1589:
1590: CURSOR ahl_sold_to_contact_count_csr(p_sold_to_contact IN VARCHAR2, p_sold_to_org_id IN NUMBER) IS
1591: SELECT COUNT(CONTACT_ID)
1592: FROM OE_CONTACTS_V
1593: WHERE NAME = p_sold_to_contact
1594: AND CUSTOMER_ID = p_sold_to_org_id;
1595:
1596: CURSOR ahl_order_vendor_detls_csr(p_osp_order_id IN NUMBER) IS