APPS.MSD_ASCP dependencies on MSD_LEVEL_VALUES

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 23: msd_level_values site,

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

Line 55: msd_level_values site,

51: IF p_level_id = 11 THEN
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