[Home] [Help]
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 '||
3280: ' WHERE a.relationship_id = b.relationship_id AND a.transaction_id = :p_transaction_id '||
3281: ' UNION SELECT a.instance_id FROM csi_i_org_assignments a, csi_i_org_assignments_h b '||
3282: ' WHERE a.instance_ou_id = b.instance_ou_id and b.transaction_id = :p_transaction_id '||
3283: ' UNION SELECT a.instance_id FROM csi_i_pricing_attribs a , csi_i_pricing_attribs_h b '||
10995: AND INSTANCE_ID=p_ins_id AND TRANSACTION_ID<>p_txn_id
10996: UNION ALL
10997:
10998: SELECT CIRH.TRANSACTION_ID TRANSACTION_ID, CIR.SUBJECT_ID INSTANCE_ID
10999: FROM CSI_II_RELATIONSHIPS_H CIRH, CSI_II_RELATIONSHIPS CIR
11000: WHERE CIRH.RELATIONSHIP_ID = CIR.RELATIONSHIP_ID
11001: AND subject_ID=p_ins_id AND TRANSACTION_ID<>p_txn_id
11002: UNION ALL
11003:
11001: AND subject_ID=p_ins_id AND TRANSACTION_ID<>p_txn_id
11002: UNION ALL
11003:
11004: SELECT CIRH.TRANSACTION_ID TRANSACTION_ID, CIR.OBJECT_ID INSTANCE_ID
11005: FROM CSI_II_RELATIONSHIPS_H CIRH, CSI_II_RELATIONSHIPS CIR
11006: WHERE CIRH.RELATIONSHIP_ID = CIR.RELATIONSHIP_ID
11007: AND object_ID=p_ins_id AND TRANSACTION_ID<>p_txn_id
11008: UNION ALL
11009: