APPS.CSP_EXCESS_LST_SERIAL_LOTS_PKG dependencies on DUAL
Line 27: CURSOR C2 IS SELECT CSP_EXCESS_LIST_SERIAL_LOTS_S1.nextval FROM sys.dual;
23: p_SERIAL_NUMBER VARCHAR2,
24: p_REVISION VARCHAR2,
25: p_LOCATOR_ID NUMBER)
26: IS 27: CURSOR C2 IS SELECT CSP_EXCESS_LIST_SERIAL_LOTS_S1.nextval FROM sys.dual; 28: BEGIN
29: If (px_EXCESS_LIST_SERIAL_LOT_ID IS NULL) OR (px_EXCESS_LIST_SERIAL_LOT_ID = FND_API.G_MISS_NUM) then
30: OPEN C2;
31: FETCH C2 INTO px_EXCESS_LIST_SERIAL_LOT_ID;