APPS.AHL_WARRANTY_ENTL_PVT dependencies on FND_LOOKUP_VALUES_VL

Line 954: FROM AHL_OSP_ORDER_LINES OSPL, FND_LOOKUP_VALUES_VL FOS

950:
951: -- cursor to get the OSP line status for the given OSP line id
952: CURSOR get_osp_line_status_csr (c_osp_line_id NUMBER) IS
953: SELECT FOS.meaning
954: FROM AHL_OSP_ORDER_LINES OSPL, FND_LOOKUP_VALUES_VL FOS
955: WHERE FOS.lookup_code = OSPL.status_code
956: AND FOS.lookup_type = 'AHL_OSP_LINE_STATUS_TYPE'
957: AND OSPL.osp_order_line_id = c_osp_line_id;
958: