APPS.MSC_SNAPSHOT_PK dependencies on MSC_PERIOD_START_DATES

Line 387: from msc_period_start_dates cal,

383: ELSE
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)

Line 399: from msc_period_start_dates cal

395: and tp.partner_type = 3;
396: ELSE
397: select min(cal.period_start_date)
398: into l_curr_start_date
399: from msc_period_start_dates cal
400: where cal.period_start_date >= trunc(sysdate)
401: and cal.calendar_code = lv_bkt_ref_calendar;
402: END IF;
403:

Line 621: msc_period_start_dates cal

617: l_msc_plan_buckets.bkt_end_date,
618: l_msc_plan_buckets.bucket_type,
619: l_msc_plan_buckets.days_in_bkt
620: FROM
621: msc_period_start_dates cal
622: WHERE
623: cal.sr_instance_id = m_sr_instance_id
624: AND cal.calendar_code = m_calendar_code
625: AND cal.exception_set_id = m_cal_exception_set_id

Line 1846: from msc_period_start_dates cal,

1842: end if;
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),