APPS.CSI_ITEM_INSTANCE_PVT dependencies on CSI_IP_ACCOUNTS_H

Line 3256: ' csi_ip_accounts_h c where a.instance_party_id = b.instance_party_id '||

3252: ' and b.transaction_id = :p_transaction_id UNION select a.instance_id '||
3253: ' from csi_i_assets a, csi_i_assets_h b where a.instance_asset_id = b.instance_asset_id '||
3254: ' and transaction_id = :p_transaction_id UNION '||
3255: ' select a.instance_id from csi_i_parties a, csi_ip_accounts b, '||
3256: ' csi_ip_accounts_h c where a.instance_party_id = b.instance_party_id '||
3257: ' and b.ip_account_id = c.ip_account_id and c.transaction_id = :p_transaction_id UNION '||
3258: ' SELECT b.instance_id FROM csi_iea_values_h a, csi_iea_values b '||
3259: ' WHERE a.attribute_value_id = b.attribute_value_id AND a.transaction_id = :p_transaction_id '||
3260: ' UNION SELECT b.subject_id FROM csi_ii_relationships_h a, csi_ii_relationships b '||

Line 10772: FROM CSI_IP_ACCOUNTS_H CIAH, CSI_IP_ACCOUNTS CIA, CSI_I_PARTIES CIP

10768: AND INSTANCE_ID=p_ins_id AND TRANSACTION_ID<>p_txn_id
10769: UNION ALL
10770:
10771: SELECT CIAH.TRANSACTION_ID TRANSACTION_ID, CIP.INSTANCE_ID INSTANCE_ID
10772: FROM CSI_IP_ACCOUNTS_H CIAH, CSI_IP_ACCOUNTS CIA, CSI_I_PARTIES CIP
10773: WHERE CIAH.IP_ACCOUNT_ID = CIA.IP_ACCOUNT_ID
10774: AND CIA.INSTANCE_PARTY_ID = CIP.INSTANCE_PARTY_ID
10775: AND INSTANCE_ID=p_ins_id AND TRANSACTION_ID<>p_txn_id
10776: UNION ALL