APPS.MSC_PHUB_PKG dependencies on MSC_TRADING_PARTNERS

Line 173: msc_trading_partners mtp

169:
170: cursor c_get_bis_minmax_dates is
171: select min(mbp.start_date) bis_min_date, max(mbp.end_date) bis_max_date
172: from msc_bis_periods mbp,
173: msc_trading_partners mtp
174: where mbp.sr_instance_id = mtp.sr_instance_id
175: and mbp.organization_id = mtp.sr_tp_id
176: and mtp.partner_type = 3
177: and mtp.organization_code||':'||period_set_name = fnd_profile.value('MSC_HUB_PERIOD_SET_NAME');