DBA Data[Home] [Help]

APPS.MSD_ASCP dependencies on MSC_TRADING_PARTNERS

Line 14: from msc_trading_partners mtp, msd_level_values mlv

10: BEGIN
11:
12: IF p_level_id = 15 THEN
13: select mtp.partner_id into v_ret
14: from msc_trading_partners mtp, msd_level_values mlv
15: where mtp.sr_instance_id = mlv.instance
16: and mlv.level_id = p_level_id
17: and mlv.level_pk = p_level_pk
18: and mtp.partner_type = 2

Line 22: from msc_trading_partners mtp,

18: and mtp.partner_type = 2
19: and mtp.sr_tp_id = mlv.sr_level_pk;
20: ELSIF p_level_id = 11 THEN
21: select mtp.partner_id into v_ret
22: from msc_trading_partners mtp,
23: msd_level_values site,
24: msd_level_associations mla
25: where site.level_id = 11
26: and site.level_pk = p_level_pk