APPS.CSI_ML_UTIL_PVT dependencies on CSI_IP_ACCOUNTS

Line 1300: FROM csi_ip_accounts

1296: AND instance_party_id IS NULL;
1297:
1298: UPDATE csi_i_party_interface a
1299: SET ip_account1_id=(SELECT ip_account_id
1300: FROM csi_ip_accounts
1301: WHERE instance_party_id = a.instance_party_id
1302: AND party_account_id = a.party_account1_id
1303: AND relationship_type_code =
1304: a.acct1_relationship_type_code)

Line 1313: FROM csi_ip_accounts

1309: AND ip_account1_id IS NULL ;
1310:
1311: UPDATE csi_i_party_interface a
1312: SET ip_account2_id = (SELECT ip_account_id
1313: FROM csi_ip_accounts
1314: WHERE instance_party_id = a.instance_party_id
1315: AND party_account_id = a.party_account2_id
1316: AND relationship_type_code =
1317: a.acct2_relationship_type_code)

Line 1326: FROM csi_ip_accounts

1322: AND ip_account2_id IS NULL;
1323:
1324: UPDATE csi_i_party_interface a
1325: SET ip_account3_id = (SELECT ip_account_id
1326: FROM csi_ip_accounts
1327: WHERE instance_party_id = a.instance_party_id
1328: AND party_account_id = a.party_account3_id
1329: AND relationship_type_code =
1330: a.acct3_relationship_type_code)

Line 1339: FROM csi_ip_accounts

1335: AND ip_account3_id IS NULL;
1336:
1337: UPDATE csi_i_party_interface a
1338: SET ip_account1_id = (SELECT ip_account_id
1339: FROM csi_ip_accounts
1340: WHERE instance_party_id = a.instance_party_id
1341: AND relationship_type_code =
1342: a.acct1_relationship_type_code)
1343: WHERE a.inst_interface_id IN (SELECT inst_interface_id

Line 1352: FROM csi_ip_accounts

1348: AND ip_account1_id IS NULL;
1349:
1350: UPDATE csi_i_party_interface a
1351: SET ip_account2_id = (SELECT ip_account_id
1352: FROM csi_ip_accounts
1353: WHERE instance_party_id = a.instance_party_id
1354: AND relationship_type_code =
1355: a.acct2_relationship_type_code)
1356: WHERE a.inst_interface_id IN (SELECT inst_interface_id

Line 1365: FROM csi_ip_accounts

1361: AND ip_account2_id IS NULL;
1362:
1363: UPDATE csi_i_party_interface a
1364: SET ip_account3_id = (SELECT ip_account_id
1365: FROM csi_ip_accounts
1366: WHERE instance_party_id = a.instance_party_id
1367: AND relationship_type_code =
1368: a.acct3_relationship_type_code)
1369: WHERE a.inst_interface_id IN (SELECT inst_interface_id