DBA Data[Home] [Help]

APPS.XTR_CASH_FCST dependencies on CE_FORECAST_ROWS

Line 36: FROM ce_forecast_rows

32: external_source_type, criteria_category,
33: criteria1, criteria2, criteria3, criteria4, criteria5,
34: criteria6, criteria7, criteria8, criteria9, criteria10,
35: criteria11, criteria12, criteria13, criteria14, criteria15
36: FROM ce_forecast_rows
37: WHERE row_number BETWEEN NVL(p_rownum_from, row_number) AND
38: NVL(p_rownum_to, row_number)
39: AND forecast_header_id = p_forecast_header_id
40: AND trx_type <> 'GLC';

Line 45: FROM ce_forecast_rows

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

Line 445: FROM ce_forecast_rows

441: PROCEDURE submit_child_requests IS
442: request_id NUMBER;
443: CURSOR CRowNumber(p_forecast_header_id NUMBER, p_rownum_from NUMBER, p_rownum_to NUMBER) IS
444: SELECT row_number
445: FROM ce_forecast_rows
446: WHERE row_number BETWEEN NVL(p_rownum_from, row_number) AND
447: NVL(p_rownum_to, row_number)
448: AND forecast_header_id = p_forecast_header_id
449: AND trx_type <> 'GLC';