APPS.OKL_ACTIVATE_IB_PVT dependencies on CSI_INSTANCE_STATUSES

Line 1512: FROM CSI_INSTANCE_STATUSES

1508: WHERE SERIAL_NUMBER = p_serial_number
1509: AND INVENTORY_ITEM_ID = p_inv_item_id
1510: AND INV_MASTER_ORGANIZATION_ID = p_inv_mstr_org_id
1511: AND INSTANCE_STATUS_ID IN (SELECT INSTANCE_STATUS_ID
1512: FROM CSI_INSTANCE_STATUSES
1513: WHERE TERMINATED_FLAG = 'N')
1514: AND NVL(ACTIVE_END_DATE,(p_khr_start_date+1)) > p_khr_start_date
1515: AND ROWNUM = 1
1516: AND NOT EXISTS