APPS.XTR_CASH_FCST dependencies on CE_FORECAST_HEADERS

Line 11: FROM CE_FORECAST_HEADERS cfh

7: CURSOR f_header_cursor (p_forecast_header_id NUMBER) IS
8: SELECT cfh.name, cfh.aging_type,
9: cfh.overdue_transactions, cfh.transaction_calendar_id,
10: cfh.start_project_id, cfh.end_project_id, cfh.treasury_template
11: FROM CE_FORECAST_HEADERS cfh
12: WHERE cfh.forecast_header_id = p_forecast_header_id;
13:
14: --
15: -- Get row information

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 97: from ce_forecast_headers

93: IF p_forecast_header_id IS NULL THEN
94: BEGIN
95: select forecast_header_id
96: into G_rp_forecast_header_id
97: from ce_forecast_headers
98: where treasury_template = 'Y';
99: EXCEPTION
100: WHEN NO_DATA_FOUND THEN
101: OPEN C;