DBA Data[Home] [Help]

APPS.MSD_ASCP dependencies on MSD_LEVEL_ASSOCIATIONS

Line 24: msd_level_associations mla

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
27: and site.instance = mla.instance
28: and site.sr_level_pk = mla.sr_level_pk

Line 56: msd_level_associations mla

52: /* look up unique reference in tps */
53: select distinct mtps.partner_site_id into v_ret
54: from msc_trading_partner_sites mtps,
55: msd_level_values site,
56: msd_level_associations mla
57: where site.level_id = p_level_id
58: and site.level_pk = p_level_pk
59: and mtps.sr_instance_id = site.instance
60: and mtps.partner_type = 2