DBA Data[Home] [Help]

APPS.CE_FORECASTS_TABLE_PKG dependencies on DUAL

Line 65: CURSOR C2 IS SELECT CE_FORECASTS_S.nextval FROM sys.dual;

61: X_attribute15 VARCHAR2) IS
62: CURSOR C1 IS SELECT rowid
63: FROM CE_FORECASTS
64: WHERE forecast_id = X_forecast_id;
65: CURSOR C2 IS SELECT CE_FORECASTS_S.nextval FROM sys.dual;
66: BEGIN
67: IF (X_forecast_id IS NULL) THEN
68: OPEN C2;
69: FETCH C2 INTO X_forecast_id;