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 645: FROM msc_calendar_dates dates

641: BEGIN
642: SELECT dates.calendar_date
643: BULK COLLECT
644: INTO v_workdate
645: FROM msc_calendar_dates dates
646: WHERE dates.calendar_code = v_calendar_code
647: AND dates.exception_set_id = v_calendar_exception_set_id
648: AND dates.sr_instance_id = arg_sr_instance_id
649: AND dates.calendar_date >= trunc(arg_start_date)

Line 1647: FROM msc_calendar_dates dates,

1643: ,FND_GLOBAL.PROG_APPL_ID /*PROGRAM_APPLICATION_ID */
1644: ,FND_GLOBAL.CONC_PROGRAM_ID /*PROGRAM_ID */
1645: ,SYSDATE /* PROGRAM_UPDATE_DATE */
1646: ,arg_refresh_number
1647: FROM msc_calendar_dates dates,
1648: msc_department_resources line,
1649: msc_trading_partners org
1650: WHERE line.organization_id = arg_organization_id
1651: AND line.sr_instance_id = arg_sr_instance_id