APPS.GMI_LOTS_PUB dependencies on DUAL

Line 312: SELECT gem5_lot_id_s.nextval INTO l_lot_id FROM dual;

308:
309: -- If no errors were found then proceed with the lot create
310:
311: -- First get the surrogate key (lot_id) for the lot
312: SELECT gem5_lot_id_s.nextval INTO l_lot_id FROM dual;
313: IF (l_lot_id <= 0)
314: THEN
315: FND_MESSAGE.SET_NAME('GMI','IC_API_UNABLE_TO_GET_SURROGATE');
316: FND_MESSAGE.SET_TOKEN('SKEY','lot_id');