DBA Data[Home] [Help]

APPS.MSC_HUB_CALENDAR dependencies on MSC_TRADING_PARTNERS

Line 101: from msc_trading_partners mtp, msc_plans mp

97:
98: l_calendar_Code := fnd_profile.value('MSC_BKT_REFERENCE_CALENDAR');
99: if (l_calendar_code is null) then
100: select mtp.calendar_code into l_calendar_code
101: from msc_trading_partners mtp, msc_plans mp
102: where mtp.sr_tp_id = mp.organization_id
103: and mtp.sr_instance_id = mp.sr_instance_id
104: and mp.plan_id =p_plan_id and mtp.PARTNER_TYPE =3;
105:

Line 328: from msc_trading_partners mtp, msc_plans mp

324:
325: l_calendar_Code := fnd_profile.value('MSC_BKT_REFERENCE_CALENDAR');
326: if (l_calendar_code is null) then
327: select mtp.calendar_code into l_calendar_code
328: from msc_trading_partners mtp, msc_plans mp
329: where mtp.sr_tp_id = mp.organization_id
330: and mtp.sr_instance_id = mp.sr_instance_id
331: and mp.plan_id =p_plan_id and mtp.PARTNER_TYPE =3;
332: