APPS.CSI_ITEM_INSTANCE_PUB dependencies on CSI_IP_ACCOUNTS

Line 1379: from csi_ip_accounts

1375: CURSOR non_owner_csr (p_ins_pty_id NUMBER) IS
1376: SELECT ip_account_id
1377: ,active_end_date
1378: ,object_version_number
1379: from csi_ip_accounts
1380: where instance_party_id=p_ins_pty_id
1381: and relationship_type_code<>'OWNER';
1382: l_tem_acct_tbl csi_datastructures_pub.party_account_tbl;
1383: l_tem_party_id NUMBER:=NULL;

Line 1730: FROM csi_ip_accounts

1726: l_cascade_account_tbl(1).party_account_id,
1727: l_cascade_account_tbl(1).relationship_type_code,
1728: l_cascade_account_tbl(1).parent_tbl_index,
1729: l_cascade_account_tbl(1).object_version_number
1730: FROM csi_ip_accounts
1731: WHERE instance_party_id=l_cascade_party_tbl(1).instance_party_id
1732: AND relationship_type_code='OWNER'
1733: AND (active_end_date IS NULL OR active_end_date>sysdate);
1734: IF p_account_tbl.count>0

Line 2306: FROM csi_ip_accounts

2302: -- The following code is added for bug 3594408 (Rel 11.5.9)
2303: BEGIN
2304: SELECT object_version_number
2305: INTO la_account_tbl(i).object_version_number
2306: FROM csi_ip_accounts
2307: WHERE ip_account_id=la_account_tbl(i).ip_account_id;
2308: EXCEPTION
2309: WHEN NO_DATA_FOUND THEN
2310: NULL;