APPS.AHL_OSP_ORDERS_PVT dependencies on AHL_GLOBAL

Line 852: AND POREQ.INTERFACE_SOURCE_CODE = AHL_GLOBAL.AHL_APP_SHORT_NAME

848: FROM PO_REQUISITION_HEADERS_ALL POREQ, AHL_OSP_ORDERS_B OSP
849: WHERE POREQ.INTERFACE_SOURCE_LINE_ID = c_osp_order_id
850: AND OSP.OSP_ORDER_ID = c_osp_order_id
851: AND OSP.OPERATING_UNIT_ID = POREQ.ORG_ID
852: AND POREQ.INTERFACE_SOURCE_CODE = AHL_GLOBAL.AHL_APP_SHORT_NAME
853: AND NVL(POREQ.CLOSED_CODE, 'X') NOT IN ('CANCELLED', 'CLOSED', 'CLOSED FOR INVOICE', 'CLOSED FOR RECEIVING',
854: 'FINALLY CLOSED', 'REJECTED', 'RETURNED');
855:
856: l_req_num VARCHAR2(20);