APPS.AHL_WARRANTY_ENTL_PVT dependencies on AHL_OSP_ORDERS_B

Line 835: FROM AHL_OSP_ORDERS_B OSPO, AHL_OSP_ORDER_LINES OSPL

831:
832: -- cursor to get the OSP order number for the given OSP line id
833: CURSOR get_osp_order_number_csr (c_osp_line_id NUMBER) IS
834: SELECT OSPO.osp_order_number
835: FROM AHL_OSP_ORDERS_B OSPO, AHL_OSP_ORDER_LINES OSPL
836: WHERE OSPO.osp_order_id = OSPL.osp_order_id
837: AND OSPL.osp_order_line_id = c_osp_line_id;
838:
839: --