DBA Data[Home] [Help]

APPS.MSC_SDA_PKG dependencies on MSC_TRADING_PARTNERS

Line 580: from msc_trading_partners mtp,

576: order by 1;
577:
578: cursor c_week_start_dates_cur(p_cal_type number, p_cal_code varchar2) is
579: select week_start_date
580: from msc_trading_partners mtp,
581: msc_cal_week_start_dates wsd
582: where p_cal_type = c_owning_org_cal
583: and mtp.sr_tp_id = g_owning_org_id
584: and mtp.sr_instance_id = g_owning_inst_id

Line 602: from msc_trading_partners mtp,

598: order by 1;
599:
600: cursor c_period_start_dates_cur(p_cal_type number, p_cal_code varchar2) is
601: select mpsd.period_start_date
602: from msc_trading_partners mtp,
603: msc_period_start_dates mpsd
604: where p_cal_type = c_owning_org_cal
605: and mpsd.calendar_code = mtp.calendar_code
606: and mpsd.sr_instance_id = mtp.sr_instance_id