APPS.MRP_SELECT_ALL_FOR_RELEASE_PUB dependencies on BOM_PERIOD_START_DATES

Line 1192: FROM bom_period_start_dates cal

1188: var_return_date := min_period_date;
1189: ELSE
1190: SELECT MIN(cal.period_start_date)
1191: INTO var_return_date
1192: FROM bom_period_start_dates cal
1193: WHERE cal.exception_set_id = var_exception_set_id
1194: AND cal.calendar_code = var_calendar_code
1195: AND cal.period_start_date >= TRUNC(arg_date);
1196: END IF;

Line 1241: FROM bom_period_start_dates

1237: AND exception_set_id = arg_exception_set_id;
1238:
1239: SELECT min(period_start_date), max(period_start_date)
1240: INTO min_period_date, max_period_date
1241: FROM bom_period_start_dates
1242: WHERE calendar_code = arg_calendar_code
1243: AND exception_set_id = arg_exception_set_id;
1244:
1245: SELECT min(week_start_date), max(week_start_date), min(seq_num),

Line 1295: FROM bom_period_start_dates cal

1291: var_prev_work_day := RELALL_PREV_WORK_DAY(arg_org_id, arg_bucket, arg_date1);
1292: var_prev_work_day2 := RELALL_PREV_WORK_DAY(arg_org_id, arg_bucket, arg_date2);
1293: SELECT count(period_start_date)
1294: INTO var_return_number
1295: FROM bom_period_start_dates cal
1296: WHERE cal.exception_set_id = var_exception_set_id
1297: AND cal.calendar_code = var_calendar_code
1298: AND cal.period_start_date between var_prev_work_day
1299: and var_prev_work_day2

Line 1354: FROM bom_period_start_dates cal

1350: var_return_date := min_period_date;
1351: ELSE
1352: SELECT MAX(cal.period_start_date)
1353: INTO var_return_date
1354: FROM bom_period_start_dates cal
1355: WHERE cal.exception_set_id = var_exception_set_id
1356: AND cal.calendar_code = var_calendar_code
1357: AND cal.period_start_date <= TRUNC(arg_date);
1358: END IF;