DBA Data[Home] [Help]

APPS.MSC_X_UTIL dependencies on MSC_TP_SITE_ID_LID

Line 569: msc_tp_site_id_lid tps,

565: BEGIN
566: SELECT tps.sr_tp_site_id into
567: l_tp_customer_site_id
568: FROM
569: msc_tp_site_id_lid tps,
570: msc_trading_partner_maps map
571: WHERE tps.sr_company_id = -1
572: and tps.tp_site_id = map.tp_key
573: and tps.sr_instance_id = l_sr_instance_id

Line 582: msc_tp_site_id_lid tps,

578: BEGIN
579: SELECT tps.sr_tp_site_id into
580: l_tp_customer_site_id
581: FROM
582: msc_tp_site_id_lid tps,
583: msc_trading_partner_sites tp_sites,
584: msc_trading_partner_maps map
585: WHERE tps.sr_company_id = -1
586: and tps.tp_site_id = tp_sites.partner_site_id