DBA Data[Home] [Help]

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