APPS.MSC_PHUB_PKG dependencies on MSC_BIS_PERIODS

Line 172: from msc_bis_periods mbp,

168: l_mfg_max_date date;
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