APPS.MRP_SELECT_ALL_FOR_RELEASE_PUB dependencies on BOM_CAL_WEEK_START_DATES

Line 1178: FROM bom_cal_week_start_dates cal

1174: var_return_date := min_week_date;
1175: ELSE
1176: SELECT MIN(cal.week_start_date)
1177: INTO var_return_date
1178: FROM bom_cal_week_start_dates cal
1179: WHERE cal.exception_set_id = var_exception_set_id
1180: AND cal.calendar_code = var_calendar_code
1181: AND cal.week_start_date >= TRUNC(arg_date);
1182: END IF;

Line 1249: FROM bom_cal_week_start_dates

1245: SELECT min(week_start_date), max(week_start_date), min(seq_num),
1246: max(seq_num)
1247: INTO min_week_date, max_week_date, min_week_seq_num,
1248: max_week_seq_num
1249: FROM bom_cal_week_start_dates
1250: WHERE calendar_code = arg_calendar_code
1251: AND exception_set_id = arg_exception_set_id;
1252:
1253: mrp_calendar_cal_code := arg_calendar_code;

Line 1341: FROM bom_cal_week_start_dates cal

1337: var_return_date := min_week_date;
1338: ELSE
1339: SELECT MAX(cal.week_start_date)
1340: INTO var_return_date
1341: FROM bom_cal_week_start_dates cal
1342: WHERE cal.exception_set_id = var_exception_set_id
1343: AND cal.calendar_code = var_calendar_code
1344: AND cal.week_start_date <= TRUNC(arg_date);
1345: END IF;

Line 1394: FROM bom_cal_week_start_dates cal

1390: var_return_number := min_week_seq_num;
1391: ELSE
1392: SELECT MAX(cal.seq_num)
1393: INTO var_return_number
1394: FROM bom_cal_week_start_dates cal
1395: WHERE cal.exception_set_id = var_exception_set_id
1396: AND cal.calendar_code = var_calendar_code
1397: AND cal.week_start_date <= TRUNC(arg_date);
1398: END IF;