APPS.AHL_OSP_SHIPMENT_PUB dependencies on OE_CONTACTS_V

Line 1627: FROM OE_CONTACTS_V

1623: AND name = p_name;
1624:
1625: CURSOR ahl_sold_to_contact_count_csr(p_sold_to_contact IN VARCHAR2, p_sold_to_org_id IN NUMBER) IS
1626: SELECT COUNT(CONTACT_ID)
1627: FROM OE_CONTACTS_V
1628: WHERE NAME = p_sold_to_contact
1629: AND CUSTOMER_ID = p_sold_to_org_id;
1630:
1631: CURSOR ahl_order_vendor_detls_csr(p_osp_order_id IN NUMBER) IS