DBA Data[Home] [Help]

APPS.MRP_WB_BUCKET_DATES_SC dependencies on BOM_CAL_WEEK_START_DATES

Line 226: FROM bom_cal_week_start_dates

222: -- beginning of the week that include var_the_date
223: -- -----------------------------------------------------------------
224: DECLARE CURSOR WEEKS IS
225: SELECT week_start_date
226: FROM bom_cal_week_start_dates
227: WHERE calendar_code = var_calendar_code
228: AND exception_set_id = var_exception_set_id
229: AND seq_num IS NOT NULL
230: AND week_start_date >= var_the_date + DECODE(counter, 0, 0, 1)

Line 236: FROM bom_cal_week_start_dates

232: ORDER BY week_start_date;
233: --
234: CURSOR HP_WEEKS IS
235: SELECT week_start_date
236: FROM bom_cal_week_start_dates
237: WHERE calendar_code = var_calendar_code
238: AND exception_set_id = var_exception_set_id
239: --AND seq_num IS NOT NULL
240: AND week_start_date >= var_the_date + DECODE(counter, 0, 0, 1)