DBA Data[Home] [Help]

APPS.CE_FORECAST_UTILS dependencies on CE_FORECAST_OPENING_BAL

Line 141: | CE_FORECAST_OPENING_BAL tables. |

137: | |
138: | DESCRIPTION |
139: | This procedure deletes all children of a particular forecast |
140: | from CE_FORECAST_CELLS, CE_FORECAST_TRX_CELLS and |
141: | CE_FORECAST_OPENING_BAL tables. |
142: | |
143: | CALLED BY |
144: | OA Controller Classes |
145: | REQUIRES |

Line 174: from ce_forecast_opening_bal

170: end if;
171:
172: select count(1)
173: into l_count
174: from ce_forecast_opening_bal
175: where forecast_id = X_forecast_id;
176:
177: if l_count > 0 then
178: delete from ce_forecast_opening_bal where forecast_id = X_forecast_id;

Line 178: delete from ce_forecast_opening_bal where forecast_id = X_forecast_id;

174: from ce_forecast_opening_bal
175: where forecast_id = X_forecast_id;
176:
177: if l_count > 0 then
178: delete from ce_forecast_opening_bal where forecast_id = X_forecast_id;
179: end if;
180:
181: select count(1)
182: into l_count