APPS.MSC_PHUB_UTIL dependencies on MSC_TRADING_PARTNERS

Line 28: from msc_trading_partners

24: l_rate number;
25: begin
26: /*select currency_code
27: into l_func_currency
28: from msc_trading_partners
29: where sr_instance_id = p_sr_instance_id
30: and organization_id = p_organization_id
31: and partner_type = 3;*/
32: l_rate := msc_phub_util.get_conversion_rate(l_func_currency, p_sr_instance_id, p_date);

Line 446: ' from msc_trading_partners mtp, msc_apps_instances mai'||

442: ' update '||p_staging_table||' f set (error_code, '||p_sr_instance_id_col||', '||p_organization_id_col||') ='||
443: ' (select 0, d.sr_instance_id, d.sr_tp_id from '||
444: ' (select mtp.sr_instance_id, mtp.sr_tp_id,'||
445: ' mtp.organization_code, mai.instance_code'||
446: ' from msc_trading_partners mtp, msc_apps_instances mai'||
447: ' where mtp.sr_instance_id=mai.instance_id'||
448: ' and mtp.partner_type=3) d'||
449: ' where f.'||p_organization_code_col||'=d.organization_code'||
450: ' and (instr(f.'||p_organization_code_col||', '':'')>0 '||

Line 1000: from msc_trading_partners o, msc_plan_runs r

996: l_owning_currency_code varchar2(20);
997: begin
998: select nvl(o.currency_code, 'XXX')
999: into l_owning_currency_code
1000: from msc_trading_partners o, msc_plan_runs r
1001: where o.sr_instance_id(+)=r.sr_instance_id
1002: and o.sr_tp_id(+)=r.organization_id
1003: and o.partner_type(+)=3
1004: and r.plan_run_id=p_plan_run_id;