DBA Data[Home] [Help]

APPS.CE_FORECAST_CELLS_PKG dependencies on DUAL

Line 19: CURSOR C2 IS SELECT CE_FORECAST_CELLS_S.nextval FROM sys.dual;

15: X_Last_Update_Login NUMBER) IS
16: CURSOR C1 IS SELECT rowid
17: FROM CE_FORECAST_CELLS
18: WHERE forecast_cell_id = X_forecast_cell_id;
19: CURSOR C2 IS SELECT CE_FORECAST_CELLS_S.nextval FROM sys.dual;
20: BEGIN
21: IF (X_forecast_cell_id IS NULL) THEN
22: OPEN C2;
23: FETCH C2 INTO X_forecast_cell_id;