DBA Data[Home] [Help]

APPS.MSC_SDA_PKG dependencies on MSC_CAL_WEEK_START_DATES

Line 593: msc_cal_week_start_dates wsd

589:
590: cursor c_week_start_dates_cur(p_cal_type number, p_cal_code varchar2) is
591: select week_start_date
592: from msc_trading_partners mtp,
593: msc_cal_week_start_dates wsd
594: where p_cal_type = c_owning_org_cal
595: and mtp.sr_tp_id = g_owning_org_id
596: and mtp.sr_instance_id = g_owning_inst_id
597: and mtp.partner_type = 3

Line 605: from msc_cal_week_start_dates mcwsd

601: and wsd.week_start_date >= g_plan_start_date
602: and wsd.week_start_date <= g_plan_end_date
603: union all
604: select mcwsd.week_start_date
605: from msc_cal_week_start_dates mcwsd
606: where p_cal_type = c_profile_cal
607: and mcwsd.calendar_code = p_cal_code
608: and mcwsd.week_start_date >= g_plan_start_date
609: and mcwsd.week_start_date <= g_plan_end_date