APPS.MSC_PHUB_FILE_PKG dependencies on MSC_TRADING_PARTNERS
Line 213: from msc_trading_partners
209:
210: begin
211: select sr_instance_id, sr_tp_id
212: into l_sr_instance_id, l_organization_id 213: from msc_trading_partners 214: where partner_type=3
215: and organization_code=p_organization_code
216: and sr_instance_id=nvl(l_sr_instance_id, sr_instance_id)
217: and rownum=1;