APPS.MSC_CALENDAR dependencies on MSC_PERIOD_START_DATES

Line 53: FROM msc_period_start_dates

49: AND sr_instance_id = arg_instance_id;
50:
51: SELECT min(period_start_date), max(period_start_date)
52: INTO min_period_date, max_period_date
53: FROM msc_period_start_dates
54: WHERE calendar_code = arg_calendar_code
55: AND exception_set_id = arg_exception_set_id
56: AND sr_instance_id = arg_instance_id;
57:

Line 98: FROM msc_period_start_dates cal

94:
95: IF arg_offset > 0 THEN
96: DECLARE CURSOR C1 IS
97: SELECT period_start_date
98: FROM msc_period_start_dates cal
99: WHERE cal.exception_set_id = var_exception_set_id
100: AND cal.calendar_code = var_calendar_code
101: AND cal.period_start_date > TRUNC(arg_date)
102: AND cal.sr_instance_id = arg_instance_id

Line 120: FROM msc_period_start_dates cal

116:
117: ELSE
118: DECLARE CURSOR C1 IS
119: SELECT period_start_date
120: FROM msc_period_start_dates cal
121: WHERE cal.exception_set_id = var_exception_set_id
122: AND cal.calendar_code = var_calendar_code
123: AND cal.period_start_date < TRUNC(arg_date)
124: AND cal.sr_instance_id = arg_instance_id

Line 287: FROM msc_period_start_dates cal

283:
284: ELSE
285: SELECT MIN(cal.period_start_date)
286: INTO var_return_date
287: FROM msc_period_start_dates cal
288: WHERE cal.exception_set_id = var_exception_set_id
289: AND cal.calendar_code = var_calendar_code
290: AND cal.period_start_date >= TRUNC(arg_date)
291: AND cal.sr_instance_id = arg_instance_id;

Line 351: FROM msc_period_start_dates cal

347: var_return_date := min_period_date;
348: ELSE
349: SELECT MAX(cal.period_start_date)
350: INTO var_return_date
351: FROM msc_period_start_dates cal
352: WHERE cal.exception_set_id = var_exception_set_id
353: AND cal.calendar_code = var_calendar_code
354: AND cal.period_start_date <= TRUNC(arg_date)
355: AND cal.sr_instance_id = arg_instance_id;

Line 547: FROM msc_period_start_dates cal

543: var_prev_work_day := PREV_WORK_DAY(arg_org_id, arg_instance_id, arg_bucket, arg_date1);
544: var_prev_work_day2 := PREV_WORK_DAY(arg_org_id, arg_instance_id, arg_bucket, arg_date2);
545: SELECT count(period_start_date)
546: INTO var_return_number
547: FROM msc_period_start_dates cal
548: WHERE cal.exception_set_id = var_exception_set_id
549: AND cal.calendar_code = var_calendar_code
550: AND cal.period_start_date between var_prev_work_day
551: and var_prev_work_day2

Line 667: FROM msc_period_start_dates

663: AND exception_set_id = arg_exception_set_id;
664:
665: SELECT min(period_start_date), max(period_start_date)
666: INTO min_period_date, max_period_date
667: FROM msc_period_start_dates
668: WHERE calendar_code = arg_calendar_code
669: AND exception_set_id = arg_exception_set_id;
670:
671: SELECT min(week_start_date), max(week_start_date), min(seq_num),

Line 757: FROM msc_period_start_dates cal

753: var_return_date := min_period_date;
754: ELSE
755: SELECT MIN(cal.period_start_date)
756: INTO var_return_date
757: FROM msc_period_start_dates cal
758: WHERE cal.exception_set_id = var_exception_set_id
759: AND cal.calendar_code = arg_calendar_code
760: AND cal.period_start_date >= TRUNC(arg_date);
761:

Line 824: FROM msc_period_start_dates cal

820: var_return_date := min_period_date;
821: ELSE
822: SELECT MAX(cal.period_start_date)
823: INTO var_return_date
824: FROM msc_period_start_dates cal
825: WHERE cal.exception_set_id = var_exception_set_id
826: AND cal.calendar_code = arg_calendar_code
827: AND cal.period_start_date <= TRUNC(arg_date);
828: END IF;