APPS.MSC_X_HZ_PLAN dependencies on MSC_PERIOD_START_DATES

Line 1238: from msc_period_start_dates

1234: and week_start_date <= SYSDATE + v_shift_days
1235: and next_date > SYSDATE + v_shift_days;
1236: else -- period_bucket_count
1237: select period_start_date into p_start_date
1238: from msc_period_start_dates
1239: where calendar_code = v_cal_code
1240: and exception_set_id = -1
1241: and period_start_date <= SYSDATE + v_shift_days
1242: and next_date > SYSDATE + v_shift_days;

Line 1282: FROM msc_calendar_dates day, msc_period_start_dates month

1278: SELECT
1279: day.calendar_date
1280: BULK COLLECT INTO
1281: daily_bucket_dates
1282: FROM msc_calendar_dates day, msc_period_start_dates month
1283: WHERE day.calendar_code = v_cal_code
1284: and day.exception_set_id = -1
1285: and day.calendar_date >= p_start_date
1286: and day.calendar_date < month.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 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 1425: from msc_period_start_dates month

1421: ELSIF (daily_bucket_count <> 0) THEN
1422: v_month_bkt_start_date := daily_bucket_dates(daily_bucket_count) + 1;
1423: ELSE
1424: select month.period_start_date into v_month_bkt_start_date
1425: from msc_period_start_dates month
1426: where month.calendar_code = v_cal_code
1427: and month.exception_set_id = -1
1428: and month.period_start_date <= p_start_date
1429: and month.next_date > p_start_date

Line 1436: from msc_period_start_dates

1432:
1433: select period_start_date
1434: BULK COLLECT INTO
1435: monthly_bucket_dates
1436: from msc_period_start_dates
1437: where calendar_code = v_cal_code
1438: and exception_set_id = -1
1439: and level <= period_bucket_count
1440: start with period_start_date <= v_month_bkt_start_date

Line 1516: from msc_period_start_dates

1512: v_last_bkt_date := v_last_bkt_date + 7;
1513: end if;
1514: else
1515: select next_date into v_last_bkt_date
1516: from msc_period_start_dates
1517: where calendar_code = v_cal_code
1518: and exception_set_id = -1
1519: and period_start_date = var_dates(counter);
1520: end if;