APPS.AHL_OSP_PO_PVT dependencies on OE_ORDER_HEADERS_ALL

Line 2801: NOT EXISTS (SELECT 1 FROM oe_order_headers_all where header_id = osp.oe_header_id);

2797: WHERE osp.status_code <> 'CLOSED' AND
2798: osp.oe_header_id IS NOT NULL AND
2799: -- Added by jaramana on April 7, 2008 for bug 6609988
2800: osp.operating_unit_id = MO_GLOBAL.get_current_org_id() AND
2801: NOT EXISTS (SELECT 1 FROM oe_order_headers_all where header_id = osp.oe_header_id);
2802:
2803: CURSOR get_osp_line_dtls_csr(c_osp_order_id IN NUMBER) IS
2804: SELECT ospl.osp_order_line_id,
2805: ospl.object_version_number,