APPS.MSC_X_HZ_PLAN dependencies on MSC_CAL_WEEK_START_DATES

Line 1231: from msc_cal_week_start_dates

1227: if daily_bucket_count <> 0 then -- from the user prefs
1228: p_start_date := trunc(sysdate) + v_shift_days;
1229: elsif weekly_bucket_count <> 0 then
1230: select week_start_date into p_start_date
1231: from msc_cal_week_start_dates
1232: where calendar_code = v_cal_code
1233: and exception_set_id = -1
1234: and week_start_date <= SYSDATE + v_shift_days
1235: and next_date > SYSDATE + v_shift_days;

Line 1264: FROM msc_calendar_dates day, msc_cal_week_start_dates week

1260: SELECT
1261: day.calendar_date
1262: BULK COLLECT INTO
1263: daily_bucket_dates
1264: FROM msc_calendar_dates day, msc_cal_week_start_dates week
1265: WHERE day.calendar_code = v_cal_code
1266: and day.exception_set_id = -1
1267: and day.calendar_date >= p_start_date
1268: and day.calendar_date < week.next_date

Line 1327: FROM msc_cal_week_start_dates week, msc_period_start_dates month

1323: SELECT
1324: week.week_start_date
1325: BULK COLLECT INTO
1326: weekly_bucket_dates
1327: FROM msc_cal_week_start_dates week, msc_period_start_dates month
1328: WHERE week.calendar_code = v_cal_code
1329: and week.exception_set_id = -1
1330: and week.week_start_date >= v_temp_date
1331: and week.week_start_date < month.next_date

Line 1341: from msc_cal_week_start_dates week

1337:
1338: weekly_bucket_count := weekly_bucket_dates.COUNT;
1339: ELSE
1340: SELECT week.week_start_date into v_temp_bucket_start_date
1341: from msc_cal_week_start_dates week
1342: where week.calendar_code = v_cal_code
1343: and week.exception_set_id = -1
1344: and week.week_start_date <= p_start_date
1345: and week.next_date > p_start_date

Line 1352: FROM msc_cal_week_start_dates week, msc_period_start_dates month

1348: SELECT
1349: week.week_start_date
1350: BULK COLLECT INTO
1351: weekly_bucket_dates
1352: FROM msc_cal_week_start_dates week, msc_period_start_dates month
1353: WHERE week.calendar_code = v_cal_code
1354: and week.exception_set_id = -1
1355: and week.next_date > v_temp_bucket_start_date
1356: and month.calendar_code = v_cal_code

Line 1371: FROM msc_cal_week_start_dates

1367: SELECT
1368: week_start_date
1369: BULK COLLECT INTO
1370: weekly_bucket_dates
1371: FROM msc_cal_week_start_dates
1372: WHERE calendar_code = v_cal_code
1373: and exception_set_id = -1
1374: and week_start_date > v_temp_date
1375: and week_start_date <= v_temp_date + 7*weekly_bucket_count

Line 1382: FROM msc_cal_week_start_dates

1378: SELECT
1379: week_start_date
1380: BULK COLLECT INTO
1381: weekly_bucket_dates
1382: FROM msc_cal_week_start_dates
1383: WHERE calendar_code = v_cal_code
1384: and exception_set_id = -1
1385: and next_date > p_start_date
1386: and next_date <= p_start_date + 7*weekly_bucket_count