APPS.XTR_CASH_FCST dependencies on DUAL

Line 78: CURSOR C IS SELECT CE_FORECASTS_S.nextval FROM sys.dual;

74:
75: l_is_fixed_rate BOOLEAN;
76: l_relationship VARCHAR2(30);
77: error_msg VARCHAR2(2000);
78: CURSOR C IS SELECT CE_FORECASTS_S.nextval FROM sys.dual;
79: CURSOR H IS SELECT CE_FORECAST_HEADERS_S.nextval FROM sys.dual;
80: BEGIN
81:
82: /* In the case where p_src_curr_type = 'Entered', ensure that there is no

Line 79: CURSOR H IS SELECT CE_FORECAST_HEADERS_S.nextval FROM sys.dual;

75: l_is_fixed_rate BOOLEAN;
76: l_relationship VARCHAR2(30);
77: error_msg VARCHAR2(2000);
78: CURSOR C IS SELECT CE_FORECASTS_S.nextval FROM sys.dual;
79: CURSOR H IS SELECT CE_FORECAST_HEADERS_S.nextval FROM sys.dual;
80: BEGIN
81:
82: /* In the case where p_src_curr_type = 'Entered', ensure that there is no
83: fixed rate between the forecast and source currencies (both EMU currencies.

Line 505: CURSOR C IS SELECT CE_FORECASTS_S.nextval FROM sys.dual;

501: fid NUMBER;
502: error_msg FND_NEW_MESSAGES.message_text%TYPE;
503: duplicate_name BOOLEAN DEFAULT FALSE;
504:
505: CURSOR C IS SELECT CE_FORECASTS_S.nextval FROM sys.dual;
506: BEGIN
507: OPEN C;
508: FETCH C INTO G_forecast_id;
509: CLOSE C;