DBA Data[Home] [Help]

APPS.MSC_ATP_PVT dependencies on MSC_TP_SITE_ID_LID

Line 1583: FROM msc_tp_site_id_lid tpsite

1579: IF (i=1) OR (l_atp_table.customer_site_id(i) <> NVL(l_atp_table.customer_site_id(i-1),-1)) THEN
1580: BEGIN
1581: SELECT TP_SITE_ID
1582: INTO MSC_ATP_PVT.G_PARTNER_SITE_ID
1583: FROM msc_tp_site_id_lid tpsite
1584: WHERE tpsite.SR_TP_SITE_ID = l_atp_table.customer_site_id(i)
1585: AND tpsite.SR_INSTANCE_ID = p_instance_id
1586: AND tpsite.PARTNER_TYPE = 2;
1587: EXCEPTION