DBA Data[Home] [Help]

APPS.MSC_HUB_CALENDAR dependencies on MSC_TRADING_PARTNERS

Line 102: from msc_trading_partners mtp, msc_plans mp

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

Line 330: from msc_trading_partners mtp, msc_plans mp

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