APPS.MRP_CALENDAR dependencies on BOM_PERIOD_START_DATES

Line 54: FROM bom_period_start_dates

50: AND exception_set_id = arg_exception_set_id;
51:
52: SELECT min(period_start_date), max(period_start_date)
53: INTO min_period_date, max_period_date
54: FROM bom_period_start_dates
55: WHERE calendar_code = arg_calendar_code
56: AND exception_set_id = arg_exception_set_id;
57:
58: SELECT min(week_start_date), max(week_start_date), min(seq_num),

Line 96: FROM bom_period_start_dates cal

92:
93: IF arg_offset > 0 THEN
94: DECLARE CURSOR C1 IS
95: SELECT period_start_date
96: FROM bom_period_start_dates cal
97: WHERE cal.exception_set_id = var_exception_set_id
98: AND cal.calendar_code = var_calendar_code
99: AND cal.period_start_date > TRUNC(arg_date);
100: BEGIN

Line 115: FROM bom_period_start_dates cal

111:
112: ELSE
113: DECLARE CURSOR C1 IS
114: SELECT period_start_date
115: FROM bom_period_start_dates cal
116: WHERE cal.exception_set_id = var_exception_set_id
117: AND cal.calendar_code = var_calendar_code
118: AND cal.period_start_date < TRUNC(arg_date)
119: ORDER BY period_start_date DESC;

Line 252: FROM bom_period_start_dates cal

248: var_return_date := min_period_date;
249: ELSE
250: SELECT MIN(cal.period_start_date)
251: INTO var_return_date
252: FROM bom_period_start_dates cal
253: WHERE cal.exception_set_id = var_exception_set_id
254: AND cal.calendar_code = var_calendar_code
255: AND cal.period_start_date >= TRUNC(arg_date);
256: END IF;

Line 311: FROM bom_period_start_dates cal

307: var_return_date := min_period_date;
308: ELSE
309: SELECT MAX(cal.period_start_date)
310: INTO var_return_date
311: FROM bom_period_start_dates cal
312: WHERE cal.exception_set_id = var_exception_set_id
313: AND cal.calendar_code = var_calendar_code
314: AND cal.period_start_date <= TRUNC(arg_date);
315: END IF;

Line 474: FROM bom_period_start_dates cal

470: var_prev_work_day := PREV_WORK_DAY(arg_org_id, arg_bucket, arg_date1);
471: var_prev_work_day2 := PREV_WORK_DAY(arg_org_id, arg_bucket, arg_date2);
472: SELECT count(period_start_date)
473: INTO var_return_number
474: FROM bom_period_start_dates cal
475: WHERE cal.exception_set_id = var_exception_set_id
476: AND cal.calendar_code = var_calendar_code
477: AND cal.period_start_date between var_prev_work_day
478: and var_prev_work_day2