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 619: msc_period_start_dates cal

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

Line 1820: from msc_period_start_dates cal,

1816: end if;
1817:
1818: select min(cal.period_start_date)
1819: into p_period_start_date
1820: from msc_period_start_dates cal,
1821: msc_trading_partners tp
1822: where cal.exception_set_id = tp.calendar_exception_set_id
1823: and cal.calendar_code = tp.calendar_code
1824: and cal.period_start_date >= nvl(trunc(v_weekly_cutoff_date),