APPS.MSC_X_RECEIVE_CAPACITY_PKG dependencies on MSC_CALENDAR_DATES

Line 436: from msc_calendar_dates

432:
433: begin
434: select sr_instance_id
435: into G_CAL_INSTANCE_ID
436: from msc_calendar_dates
437: where calendar_code = G_MSC_X_DEF_CALENDAR
438: and rownum = 1;
439: LOG_MESSAGE( 'Calendar from Profile: ' || G_MSC_X_DEF_CALENDAR);
440: LOG_MESSAGE( 'Instance id : ' || G_CAL_INSTANCE_ID);

Line 1085: -- of the calendar_code from msc_calendar_dates. The default calendar code for

1081: -- Reason: Example weekly bucket. If we bring in 7-0 calendar code capacity,
1082: -- when running a plan based on a 5-2 calendar code, then will be missing 2 days
1083: -- capacities in PWB.
1084: -- Solution: A new parameter for calendar code is introduced. This LOV is a list
1085: -- of the calendar_code from msc_calendar_dates. The default calendar code for
1086: -- this LOV is based on a production plan (from msc_designator where production = 1)
1087: -- If user not to choose any calendar code, or no calendar code is found, then
1088: -- we use the default 7-0 calendar.
1089: ---------------------------------------------------------------------------------