DBA Data[Home] [Help]

APPS.MSC_ATP_PVT dependencies on MSC_TP_ID_LID

Line 1559: FROM msc_tp_id_lid tp

1555: IF (i=1) OR (l_atp_table.customer_id(i) <> NVL(l_atp_table.customer_id(i-1),-1)) THEN
1556: BEGIN
1557: SELECT TP_ID
1558: INTO MSC_ATP_PVT.G_PARTNER_ID
1559: FROM msc_tp_id_lid tp
1560: WHERE tp.SR_TP_ID = l_atp_table.customer_id(i)
1561: AND tp.SR_INSTANCE_ID = p_instance_id
1562: AND tp.PARTNER_TYPE = 2;
1563: EXCEPTION