APPS.CE_CASH_FCST dependencies on CE_FORECAST_ROWS

Line 38: FROM ce_forecast_rows

34: criteria6, criteria7, criteria8, criteria9, criteria10,
35: criteria11, criteria12, criteria13, criteria14, criteria15,
36: use_average_payment_days, period, order_type_id,
37: use_payment_terms, include_temp_labor_flag
38: FROM ce_forecast_rows
39: WHERE row_number BETWEEN NVL(p_rownum_from, row_number) AND
40: NVL(p_rownum_to, row_number)
41: AND forecast_header_id = p_forecast_header_id
42: AND trx_type <> 'GLC';

Line 48: FROM ce_forecast_rows

44: CURSOR f_glc_cursor (p_forecast_header_id NUMBER, p_rownum_from NUMBER, p_rownum_to NUMBER) IS
45:
46: SELECT rowid, forecast_row_id, row_number,
47: set_of_books_id, code_combination_id, chart_of_accounts_id
48: FROM ce_forecast_rows
49: WHERE row_number BETWEEN NVL(p_rownum_from, row_number) AND
50: NVL(p_rownum_to, row_number)
51: AND forecast_header_id = p_forecast_header_id
52: AND trx_type = 'GLC';

Line 420: FROM ce_forecast_rows r,

416: NVL(end_date_active,CE_CASH_FCST.G_rp_exchange_date));
417:
418: CURSOR base_curr IS
419: SELECT distinct(org.currency_code)
420: FROM ce_forecast_rows r,
421: ce_forecast_oe_orgs_v org
422: WHERE r.row_number BETWEEN
423: NVL(CE_CASH_FCST.G_rp_rownum_from, row_number) and
424: NVL(CE_CASH_FCST.G_rp_rownum_to, row_number)

Line 1114: FROM ce_forecast_rows

1110: PROCEDURE submit_child_requests IS
1111: request_id NUMBER;
1112: CURSOR CRowNumber(p_forecast_header_id NUMBER, p_rownum_from NUMBER, p_rownum_to NUMBER) IS
1113: SELECT row_number
1114: FROM ce_forecast_rows
1115: WHERE row_number BETWEEN NVL(p_rownum_from, row_number) AND
1116: NVL(p_rownum_to, row_number)
1117: AND forecast_header_id = p_forecast_header_id
1118: AND trx_type <> 'GLC';