[Home] [Help]
287: mpl.sr_instance_id,
288: TRUNC(sysdate),
289: mpl.cutoff_date
290: FROM
291: msc_trading_partners mtp,
292: msc_plans mpl
293: WHERE
294: mpl.plan_id = p_plan_id
295: and mpl.organization_id = mtp.sr_tp_id
354: IF (lv_bkt_ref_calendar is null) then
355: select min(cal.week_start_date)
356: into l_curr_start_date
357: from msc_cal_week_start_dates cal,
358: msc_trading_partners tp,
359: msc_calendar_dates mc
360: where cal.exception_set_id = tp.calendar_exception_set_id
361: and mc.exception_set_id = tp.calendar_exception_set_id
362: and cal.calendar_code = tp.calendar_code
384: IF (lv_bkt_ref_calendar is null) then
385: select min(cal.period_start_date)
386: into l_curr_start_date
387: from msc_period_start_dates cal,
388: msc_trading_partners tp
389: where cal.exception_set_id = tp.calendar_exception_set_id
390: and cal.calendar_code = tp.calendar_code
391: and cal.period_start_date >= trunc(sysdate)
392: and cal.sr_instance_id = tp.sr_instance_id
482: tp.calendar_exception_set_id ,
483: decode(fnd_profile.value('MSC_BKT_REFERENCE_CALENDAR'), NULL, tp.sr_instance_id, mcd.sr_instance_id)
484: into m_calendar_code , m_cal_exception_set_id , m_sr_instance_id
485: from msc_plans mp,
486: msc_trading_partners tp,
487: msc_calendar_dates mcd
488: where mp.plan_id = p_plan_id
489: and tp.partner_type = 3
490: and tp.sr_instance_id = mp.sr_instance_id
1828:
1829: select min(cal.week_start_date)
1830: into p_weekly_start_date
1831: from msc_cal_week_start_dates cal,
1832: msc_trading_partners tp
1833: where cal.exception_set_id = tp.calendar_exception_set_id
1834: and cal.calendar_code = tp.calendar_code
1835: and cal.week_start_date >= trunc(v_daily_cutoff_date)
1836: and cal.sr_instance_id = tp.sr_instance_id
1843:
1844: select min(cal.period_start_date)
1845: into p_period_start_date
1846: from msc_period_start_dates cal,
1847: msc_trading_partners tp
1848: where cal.exception_set_id = tp.calendar_exception_set_id
1849: and cal.calendar_code = tp.calendar_code
1850: and cal.period_start_date >= nvl(trunc(v_weekly_cutoff_date),
1851: trunc(v_daily_cutoff_date))