DBA Data[Home] [Help]

APPS.BOM_MIXED_MODEL_MAP_PVT dependencies on BOM_CAL_WEEK_START_DATES

Line 79: FROM bom_cal_week_start_dates cal

75: BEGIN
76: IF (x_bucket = G_WEEKS) THEN
77: SELECT count(week_start_date)
78: INTO l_buckets
79: FROM bom_cal_week_start_dates cal
80: WHERE cal.exception_set_id = x_exception_set_id
81: AND cal.calendar_code = x_calendar_code
82: AND cal.week_start_date between x_start_date
83: and x_end_date;

Line 152: FROM bom_cal_week_start_dates

148:
149: CURSOR GetLastDay IS
150: SELECT decode(next_date, week_start_date,
151: x_last_calendar_date, (next_date -1)) last_day
152: FROM bom_cal_week_start_dates
153: WHERE calendar_code = x_calendar_code
154: AND exception_set_id = x_exception_set_id
155: AND week_start_date = nvl(x_rate_end_date, x_forecast_date);
156: BEGIN