APPS.MSC_SDA_PKG dependencies on MSC_TRADING_PARTNERS

Line 592: from msc_trading_partners mtp,

588: order by 1;
589:
590: cursor c_week_start_dates_cur(p_cal_type number, p_cal_code varchar2) is
591: select week_start_date
592: from msc_trading_partners mtp,
593: msc_cal_week_start_dates wsd
594: where p_cal_type = c_owning_org_cal
595: and mtp.sr_tp_id = g_owning_org_id
596: and mtp.sr_instance_id = g_owning_inst_id

Line 614: from msc_trading_partners mtp,

610: order by 1;
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

Line 3463: from msc_trading_partners mtp,

3459: date1, date2, number1)
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