1618: IF (i=1) OR (l_atp_table.customer_id(i) <> NVL(l_atp_table.customer_id(i-1),-1)) THEN
1619: BEGIN
1620: SELECT TP_ID
1621: INTO MSC_ATP_PVT.G_PARTNER_ID 1622: FROM msc_tp_id_lid tp 1623: WHERE tp.SR_TP_ID = l_atp_table.customer_id(i)
1624: AND tp.SR_INSTANCE_ID = p_instance_id
1625: AND tp.PARTNER_TYPE = 2;
1626: EXCEPTION