APPS.MRP_REPORTING_BUCKETS dependencies on BOM_CAL_WEEK_START_DATES

Line 27: FROM bom_cal_week_start_dates

23: | Weeks cursor |
24: +-------------------------------------------------------------------------*/
25: CURSOR weeks_cur IS
26: SELECT week_start_date
27: FROM bom_cal_week_start_dates
28: WHERE calendar_code = var_calendar_code
29: AND exception_set_id = var_exception_set_id
30: AND week_start_date >=
31: (SELECT max(week_start_date)

Line 32: FROM bom_cal_week_start_dates

28: WHERE calendar_code = var_calendar_code
29: AND exception_set_id = var_exception_set_id
30: AND week_start_date >=
31: (SELECT max(week_start_date)
32: FROM bom_cal_week_start_dates
33: WHERE week_start_date <= TRUNC(arg_start_date)
34: AND calendar_code = var_calendar_code
35: AND exception_set_id = var_exception_set_id)
36: ORDER BY week_start_date;