DBA Data[Home] [Help]

APPS.MSC_ATP_PVT dependencies on MSC_TP_SITE_ID_LID

Line 1646: FROM msc_tp_site_id_lid tpsite

1642: IF (i=1) OR (l_atp_table.customer_site_id(i) <> NVL(l_atp_table.customer_site_id(i-1),-1)) THEN
1643: BEGIN
1644: SELECT TP_SITE_ID
1645: INTO MSC_ATP_PVT.G_PARTNER_SITE_ID
1646: FROM msc_tp_site_id_lid tpsite
1647: WHERE tpsite.SR_TP_SITE_ID = l_atp_table.customer_site_id(i)
1648: AND tpsite.SR_INSTANCE_ID = p_instance_id
1649: AND tpsite.PARTNER_TYPE = 2;
1650: EXCEPTION