APPS.CSI_ITEM_INSTANCE_PVT dependencies on CSI_IP_ACCOUNTS_H

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

3271: ' and b.transaction_id = :p_transaction_id UNION select a.instance_id '||
3272: ' from csi_i_assets a, csi_i_assets_h b where a.instance_asset_id = b.instance_asset_id '||
3273: ' and transaction_id = :p_transaction_id UNION '||
3274: ' select a.instance_id from csi_i_parties a, csi_ip_accounts b, '||
3275: ' csi_ip_accounts_h c where a.instance_party_id = b.instance_party_id '||
3276: ' and b.ip_account_id = c.ip_account_id and c.transaction_id = :p_transaction_id UNION '||
3277: ' SELECT b.instance_id FROM csi_iea_values_h a, csi_iea_values b '||
3278: ' WHERE a.attribute_value_id = b.attribute_value_id AND a.transaction_id = :p_transaction_id '||
3279: ' UNION SELECT b.subject_id FROM csi_ii_relationships_h a, csi_ii_relationships b '||

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

11019: AND INSTANCE_ID=p_ins_id AND TRANSACTION_ID<>p_txn_id
11020: UNION ALL
11021:
11022: SELECT CIAH.TRANSACTION_ID TRANSACTION_ID, CIP.INSTANCE_ID INSTANCE_ID
11023: FROM CSI_IP_ACCOUNTS_H CIAH, CSI_IP_ACCOUNTS CIA, CSI_I_PARTIES CIP
11024: WHERE CIAH.IP_ACCOUNT_ID = CIA.IP_ACCOUNT_ID
11025: AND CIA.INSTANCE_PARTY_ID = CIP.INSTANCE_PARTY_ID
11026: AND INSTANCE_ID=p_ins_id AND TRANSACTION_ID<>p_txn_id
11027: UNION ALL