DBA Data[Home] [Help]

APPS.CSI_ITEM_INSTANCE_PVT dependencies on CSI_I_PARTIES_H

Line 3251: ' from csi_i_parties a, csi_i_parties_h b where a.instance_party_id = b.instance_party_id '||

3247: --End Addition
3248:
3249: l_union_stmt VARCHAR2(2000) := ' select instance_id from csi_item_instances_h '||
3250: ' where transaction_id = :p_transaction_id UNION select a.instance_id '||
3251: ' from csi_i_parties a, csi_i_parties_h b 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, '||

Line 10760: FROM CSI_I_PARTIES_H CIPH, CSI_I_PARTIES CIP

10756: AND object_ID=p_ins_id AND TRANSACTION_ID<>p_txn_id
10757: UNION ALL
10758:
10759: SELECT CIPH.TRANSACTION_ID TRANSACTION_ID, CIP.INSTANCE_ID INSTANCE_ID
10760: FROM CSI_I_PARTIES_H CIPH, CSI_I_PARTIES CIP
10761: WHERE CIPH.INSTANCE_PARTY_ID = CIP.INSTANCE_PARTY_ID
10762: AND INSTANCE_ID=p_ins_id AND TRANSACTION_ID<>p_txn_id
10763: UNION ALL
10764: