APPS.MRP_CALENDAR dependencies on BOM_CAL_WEEK_START_DATES

Line 62: FROM bom_cal_week_start_dates

58: SELECT min(week_start_date), max(week_start_date), min(seq_num),
59: max(seq_num)
60: INTO min_week_date, max_week_date, min_week_seq_num,
61: max_week_seq_num
62: FROM bom_cal_week_start_dates
63: WHERE calendar_code = arg_calendar_code
64: AND exception_set_id = arg_exception_set_id;
65:
66: mrp_calendar_cal_code := arg_calendar_code;

Line 178: FROM bom_cal_week_start_dates cal

174: BEGIN
175: BEGIN
176: SELECT week_start_date
177: INTO var_return_date
178: FROM bom_cal_week_start_dates cal
179: WHERE cal.exception_set_id = var_exception_set_id
180: AND cal.calendar_code = var_calendar_code
181: AND cal.seq_num = arg_seq_num + arg_offset;
182: EXCEPTION

Line 238: FROM bom_cal_week_start_dates cal

234: var_return_date := min_week_date;
235: ELSE
236: SELECT MIN(cal.week_start_date)
237: INTO var_return_date
238: FROM bom_cal_week_start_dates cal
239: WHERE cal.exception_set_id = var_exception_set_id
240: AND cal.calendar_code = var_calendar_code
241: AND cal.week_start_date >= TRUNC(arg_date);
242: END IF;

Line 298: FROM bom_cal_week_start_dates cal

294: var_return_date := min_week_date;
295: ELSE
296: SELECT MAX(cal.week_start_date)
297: INTO var_return_date
298: FROM bom_cal_week_start_dates cal
299: WHERE cal.exception_set_id = var_exception_set_id
300: AND cal.calendar_code = var_calendar_code
301: AND cal.week_start_date <= TRUNC(arg_date);
302: END IF;

Line 353: FROM bom_cal_week_start_dates cal

349: var_return_number := min_seq_num;
350: ELSE
351: SELECT MIN(cal.seq_num)
352: INTO var_return_number
353: FROM bom_cal_week_start_dates cal
354: WHERE cal.exception_set_id = var_exception_set_id
355: AND cal.calendar_code = var_calendar_code
356: AND cal.week_start_date >= TRUNC(arg_date);
357: END IF;

Line 396: FROM bom_cal_week_start_dates cal

392: var_return_number := min_week_seq_num;
393: ELSE
394: SELECT MAX(cal.seq_num)
395: INTO var_return_number
396: FROM bom_cal_week_start_dates cal
397: WHERE cal.exception_set_id = var_exception_set_id
398: AND cal.calendar_code = var_calendar_code
399: AND cal.week_start_date <= TRUNC(arg_date);
400: END IF;