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 406: FROM ce_forecast_rows r,

402: NVL(end_date_active,CE_CASH_FCST.G_rp_exchange_date));
403:
404: CURSOR base_curr IS
405: SELECT distinct(org.currency_code)
406: FROM ce_forecast_rows r,
407: ce_forecast_oe_orgs_v org
408: WHERE r.row_number BETWEEN
409: NVL(CE_CASH_FCST.G_rp_rownum_from, row_number) and
410: NVL(CE_CASH_FCST.G_rp_rownum_to, row_number)

Line 1100: FROM ce_forecast_rows

1096: PROCEDURE submit_child_requests IS
1097: request_id NUMBER;
1098: CURSOR CRowNumber(p_forecast_header_id NUMBER, p_rownum_from NUMBER, p_rownum_to NUMBER) IS
1099: SELECT row_number
1100: FROM ce_forecast_rows
1101: WHERE row_number BETWEEN NVL(p_rownum_from, row_number) AND
1102: NVL(p_rownum_to, row_number)
1103: AND forecast_header_id = p_forecast_header_id
1104: AND trx_type <> 'GLC';