APPS.MRP_REPORTING_BUCKETS dependencies on BOM_PERIOD_START_DATES

Line 42: FROM bom_period_start_dates

38: | Months cursor |
39: +-------------------------------------------------------------------------*/
40: CURSOR months_cur IS
41: SELECT period_start_date
42: FROM bom_period_start_dates
43: WHERE calendar_code = var_calendar_code
44: AND exception_set_id = var_exception_set_id
45: AND period_start_date >=
46: (SELECT max(period_start_date)

Line 47: FROM bom_period_start_dates

43: WHERE calendar_code = var_calendar_code
44: AND exception_set_id = var_exception_set_id
45: AND period_start_date >=
46: (SELECT max(period_start_date)
47: FROM bom_period_start_dates
48: WHERE period_start_date <= var_month_start_date
49: AND calendar_code = var_calendar_code
50: AND exception_set_id = var_exception_set_id)
51: ORDER BY period_start_date;

Line 114: FROM bom_period_start_dates

110: var_month_start_date := arg_start_date;
111: ELSE
112: SELECT min(period_start_date)
113: INTO var_month_start_date
114: FROM bom_period_start_dates
115: WHERE period_start_date > var_week_bucket_date
116: AND calendar_code = var_calendar_code
117: AND exception_Set_id = var_exception_set_id;
118: END IF;