DBA Data[Home] [Help]

APPS.BOM_MIXED_MODEL_MAP_PVT dependencies on BOM_PERIOD_START_DATES

Line 87: FROM bom_period_start_dates cal

83: and x_end_date;
84: ELSIF (x_bucket = G_PERIODS) THEN
85: SELECT count(period_start_date)
86: INTO l_buckets
87: FROM bom_period_start_dates cal
88: WHERE cal.exception_set_id = x_exception_set_id
89: AND cal.calendar_code = x_calendar_code
90: AND cal.period_start_date between x_start_date
91: and x_end_date;

Line 186: FROM bom_period_start_dates

182: l_last_period_day DATE;
183: CURSOR GetLastDay IS
184: SELECT decode(next_date, period_start_date,
185: x_last_calendar_date, (next_date -1)) last_day
186: FROM bom_period_start_dates
187: WHERE calendar_code = x_calendar_code
188: AND exception_set_id = x_exception_set_id
189: AND period_start_date = nvl(x_rate_end_date, x_forecast_date);
190: BEGIN