APPS.BIL_BI_PURGE_OBJ_PKG dependencies on AS_INTERNAL_FORECASTS
Line 727: FROM as_internal_forecasts intrnl,
723: g_row_num := SQL%ROWCOUNT;
724:
725: DELETE FROM bil_bi_processed_fst_id
726: WHERE forecast_id in ( SELECT intrnl.forecast_id f 727: FROM as_internal_forecasts intrnl, 728: gl_periods gl
729: WHERE gl.period_name = intrnl.period_name
730: AND gl.period_set_name = l_val(3)
731: AND gl.end_date <= g_end_date