APPS.CSI_ITEM_INSTANCE_PUB dependencies on CSI_IP_ACCOUNTS

Line 1399: from csi_ip_accounts

1395: CURSOR non_owner_csr (p_ins_pty_id NUMBER) IS
1396: SELECT ip_account_id
1397: ,active_end_date
1398: ,object_version_number
1399: from csi_ip_accounts
1400: where instance_party_id=p_ins_pty_id
1401: and relationship_type_code<>'OWNER';
1402: l_tem_acct_tbl csi_datastructures_pub.party_account_tbl;
1403: l_tem_party_id NUMBER:=NULL;

Line 1812: FROM csi_ip_accounts

1808: l_cascade_account_tbl(1).party_account_id,
1809: l_cascade_account_tbl(1).relationship_type_code,
1810: l_cascade_account_tbl(1).parent_tbl_index,
1811: l_cascade_account_tbl(1).object_version_number
1812: FROM csi_ip_accounts
1813: WHERE instance_party_id=l_cascade_party_tbl(1).instance_party_id
1814: AND relationship_type_code='OWNER'
1815: AND (active_end_date IS NULL OR active_end_date>sysdate);
1816: IF p_account_tbl.count>0

Line 2389: FROM csi_ip_accounts

2385: -- The following code is added for bug 3594408 (Rel 11.5.9)
2386: BEGIN
2387: SELECT object_version_number
2388: INTO la_account_tbl(i).object_version_number
2389: FROM csi_ip_accounts
2390: WHERE ip_account_id=la_account_tbl(i).ip_account_id;
2391: EXCEPTION
2392: WHEN NO_DATA_FOUND THEN
2393: NULL;