APPS.MSC_X_USER_EXCEP_GEN dependencies on MSC_PARTNER_CONTACTS

Line 234: FROM msc_partner_contacts cont,

230: lNtfId Number;
231: --if item and org are there
232: cursor buyer_c1(p_item IN VARCHAR2,p_org IN VARCHAR2) is
233: SELECT cont.name
234: FROM msc_partner_contacts cont,
235: msc_system_items sys,
236: msc_trading_partners mtp
237: WHERE sys.item_name = p_item
238: AND sys.plan_id = -1

Line 250: FROM msc_partner_contacts cont,

246: --if item is there but not the org
247:
248: cursor buyer_c2(p_item IN VARCHAR2) is
249: SELECT cont.name
250: FROM msc_partner_contacts cont,
251: msc_system_items sys,
252: msc_trading_partners mtp
253: WHERE sys.item_name = p_item
254: AND sys.plan_id = -1

Line 367: msc_partner_contacts mpc,

363: cursor SupplierContact_c(p_sup_name IN VARCHAR2,p_sup_site_name IN VARCHAR2,p_publisher_site_name IN VARCHAR2) is
364: select
365: distinct mpc.name
366: from
367: msc_partner_contacts mpc,
368: msc_trading_partners mtp,
369: msc_trading_partner_sites mtps,
370: msc_trading_partners mtporg
371: where

Line 388: msc_partner_contacts mpc,

384: cursor sup_modelled_org_c(p_sup_name IN VARCHAR2,p_sup_site_name IN VARCHAR2) is
385: select
386: distinct mpc.name
387: from
388: msc_partner_contacts mpc,
389: msc_trading_partners mtp,
390: msc_trading_partners mtporg
391: where
392: mpc.partner_id=mtp.MODELED_SUPPLIER_ID