APPS.MSC_NET_RES_INST_AVAILABILITY dependencies on MSC_CALENDAR_DATES

Line 42: from msc_calendar_dates cal

38:
39: --v_stmt := 10;
40: select TRUNC(MIN(calendar_date))
41: into v_start_date
42: from msc_calendar_dates cal
43: ,msc_trading_partners tp
44: where tp.sr_tp_id = arg_organization_id
45: and tp.sr_instance_id = arg_sr_instance_id
46: and tp.partner_type = 3

Line 71: from msc_calendar_dates cal

67:
68: --v_stmt := 20;
69: select TRUNC(MAX(calendar_date))
70: into v_cutoff_date
71: from msc_calendar_dates cal
72: ,msc_trading_partners tp
73: where tp.sr_tp_id = arg_organization_id
74: and tp.sr_instance_id = arg_sr_instance_id
75: and tp.partner_type = 3

Line 549: FROM msc_calendar_dates dates,

545: var_gt_application,
546: var_gt_conc_program,
547: sysdate,
548: arg_refresh_number
549: FROM msc_calendar_dates dates,
550: msc_department_resources dept_res1,
551: msc_dept_res_instances dept_ins,
552: msc_trading_partners param
553: WHERE dates.calendar_code = param.calendar_code