DBA Data[Home] [Help]

APPS.MSC_ATP_PVT dependencies on MSC_TP_ID_LID

Line 1622: FROM msc_tp_id_lid tp

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