APPS.MSC_SDA_PKG dependencies on MSC_PERIOD_START_DATES

Line 615: msc_period_start_dates mpsd

611:
612: cursor c_period_start_dates_cur(p_cal_type number, p_cal_code varchar2) is
613: select mpsd.period_start_date
614: from msc_trading_partners mtp,
615: msc_period_start_dates mpsd
616: where p_cal_type = c_owning_org_cal
617: and mpsd.calendar_code = mtp.calendar_code
618: and mpsd.sr_instance_id = mtp.sr_instance_id
619: and mpsd.exception_set_id = mtp.calendar_exception_set_id

Line 627: from msc_period_start_dates mpsd

623: and mpsd.period_start_date >= g_plan_start_date
624: and mpsd.period_start_date <= g_plan_end_date
625: union all
626: select mpsd.period_start_date
627: from msc_period_start_dates mpsd
628: where p_cal_type = c_profile_cal
629: and mpsd.calendar_code = p_cal_code
630: and mpsd.period_start_date >= g_plan_start_date
631: and mpsd.period_start_date <= g_plan_end_date

Line 3464: msc_period_start_dates mpsd

3460: select g_hist_cal_query_id, sysdate, -1, -1, sysdate, start_date, end_date,1
3461: from (
3462: select mpsd.period_start_date start_date, mpsd.next_date-1 end_date
3463: from msc_trading_partners mtp,
3464: msc_period_start_dates mpsd
3465: where l_cal_type = c_owning_org_cal
3466: and mpsd.calendar_code = mtp.calendar_code
3467: and mpsd.sr_instance_id = mtp.sr_instance_id
3468: and mpsd.exception_set_id = mtp.calendar_exception_set_id

Line 3476: from msc_period_start_dates mpsd

3472: and mpsd.period_start_date >= g_pref_hist_start_date
3473: and mpsd.period_start_date <= g_plan_start_date
3474: union all
3475: select mpsd.period_start_date start_date, mpsd.next_date-1 end_date
3476: from msc_period_start_dates mpsd
3477: where l_cal_type = c_profile_cal
3478: and mpsd.calendar_code = l_cal_code
3479: and mpsd.period_start_date >= g_pref_hist_start_date
3480: and mpsd.period_start_date <= g_plan_start_date