APPS.MSC_HP_UTIL dependencies on MSC_PLANS

Line 15: from msc_trading_partners mtp, msc_plans mp

11: l_calendar_code := fnd_profile.value('MSC_BKT_REFERENCE_CALENDAR'); -- l_calendar_code
12: if (l_calendar_code is null) then
13: select mtp.calendar_code
14: into l_calendar_code
15: from msc_trading_partners mtp, msc_plans mp
16: where mtp.sr_tp_id=mp.organization_id
17: and mtp.sr_instance_id=mp.sr_instance_id
18: and mp.plan_id=p_plan_id
19: and mtp.partner_type=3;