APPS.MSC_RESOURCE_AVAILABILITY dependencies on MSC_CALENDAR_DATES

Line 69: from msc_calendar_dates cal

65:
66: v_stmt := 10;
67: select TRUNC(MIN(calendar_date))
68: into v_start_date
69: from msc_calendar_dates cal
70: ,msc_trading_partners tp
71: where tp.sr_tp_id = arg_organization_id
72: and tp.sr_instance_id = arg_sr_instance_id
73: and tp.partner_type = 3

Line 98: from msc_calendar_dates cal

94:
95: v_stmt := 20;
96: select TRUNC(MAX(calendar_date))
97: into v_cutoff_date
98: from msc_calendar_dates cal
99: ,msc_trading_partners tp
100: where tp.sr_tp_id = arg_organization_id
101: and tp.sr_instance_id = arg_sr_instance_id
102: and tp.partner_type = 3

Line 633: FROM msc_calendar_dates dates

629: BEGIN
630: SELECT dates.calendar_date
631: BULK COLLECT
632: INTO v_workdate
633: FROM msc_calendar_dates dates
634: WHERE dates.calendar_code = v_calendar_code
635: AND dates.exception_set_id = v_calendar_exception_set_id
636: AND dates.sr_instance_id = arg_sr_instance_id
637: AND dates.calendar_date >= trunc(arg_start_date)

Line 1635: FROM msc_calendar_dates dates,

1631: ,FND_GLOBAL.PROG_APPL_ID /*PROGRAM_APPLICATION_ID */
1632: ,FND_GLOBAL.CONC_PROGRAM_ID /*PROGRAM_ID */
1633: ,SYSDATE /* PROGRAM_UPDATE_DATE */
1634: ,arg_refresh_number
1635: FROM msc_calendar_dates dates,
1636: msc_department_resources line,
1637: msc_trading_partners org
1638: WHERE line.organization_id = arg_organization_id
1639: AND line.sr_instance_id = arg_sr_instance_id