APPS.MRP_CALENDAR dependencies on BOM_CALENDAR_DATES

Line 47: FROM bom_calendar_dates bom

43:
44: SELECT /*+ index_ffs(bom) */ min(calendar_date), max(calendar_date), min(seq_num),
45: max(seq_num)
46: INTO min_date, max_date, min_seq_num, max_seq_num
47: FROM bom_calendar_dates bom
48: WHERE calendar_code = arg_calendar_code
49: AND seq_num is not null
50: AND exception_set_id = arg_exception_set_id;
51:

Line 148: FROM bom_calendar_dates cal

144: BEGIN
145: BEGIN
146: SELECT calendar_date
147: INTO var_return_date
148: FROM bom_calendar_dates cal
149: WHERE cal.exception_set_id = var_exception_set_id
150: AND cal.calendar_code = var_calendar_code
151: AND cal.seq_num = arg_seq_num + arg_offset;
152:

Line 224: FROM bom_calendar_dates cal

220: var_return_date := min_date;
221: ELSE
222: SELECT cal.next_date
223: INTO var_return_date
224: FROM bom_calendar_dates cal
225: WHERE cal.exception_set_id = var_exception_set_id
226: AND cal.calendar_code = var_calendar_code
227: AND cal.calendar_date = TRUNC(arg_date);
228: END IF;

Line 285: FROM bom_calendar_dates cal

281: var_return_date := min_date;
282: ELSE
283: SELECT cal.prior_date
284: INTO var_return_date
285: FROM bom_calendar_dates cal
286: WHERE cal.exception_set_id = var_exception_set_id
287: AND cal.calendar_code = var_calendar_code
288: AND cal.calendar_date = TRUNC(arg_date);
289: END IF;

Line 340: FROM bom_calendar_dates cal

336: var_return_number := min_seq_num;
337: ELSE
338: SELECT cal.next_seq_num
339: INTO var_return_number
340: FROM bom_calendar_dates cal
341: WHERE cal.exception_set_id = var_exception_set_id
342: AND cal.calendar_code = var_calendar_code
343: AND cal.calendar_date = TRUNC(arg_date);
344: END IF;

Line 383: FROM bom_calendar_dates cal

379: var_return_number := min_seq_num;
380: ELSE
381: SELECT cal.prior_seq_num
382: INTO var_return_number
383: FROM bom_calendar_dates cal
384: WHERE cal.exception_set_id = var_exception_set_id
385: AND cal.calendar_code = var_calendar_code
386: AND cal.calendar_date = TRUNC(arg_date);
387: END IF;