DBA Data[Home] [Help]

APPS.CSI_ML_UTIL_PVT dependencies on CSI_I_PARTIES

Line 1248: FROM csi_i_parties

1244: CLOSE pty3_intf_cur;
1245:
1246: UPDATE csi_i_party_interface a
1247: SET instance_party_id = (SELECT instance_party_id
1248: FROM csi_i_parties
1249: WHERE party_id = a.party_id
1250: AND instance_id =
1251: (SELECT instance_id
1252: FROM csi_instance_interface cii

Line 1266: FROM csi_i_parties

1262: AND a.party_id IS NOT NULL;
1263:
1264: UPDATE csi_i_party_interface a
1265: SET contact_ip_id = (SELECT instance_party_id
1266: FROM csi_i_parties
1267: WHERE party_id = a.contact_party_id
1268: AND instance_id =
1269: (SELECT instance_id
1270: FROM csi_instance_interface cii

Line 1284: FROM csi_i_parties

1280: AND a.contact_party_id IS NOT NULL;
1281:
1282: UPDATE csi_i_party_interface a
1283: SET instance_party_id = (SELECT instance_party_id
1284: FROM csi_i_parties
1285: WHERE instance_id =
1286: (SELECT instance_id
1287: FROM csi_instance_interface cii
1288: WHERE cii.inst_interface_id=a.inst_interface_id)