APPS.CSI_ITEM_INSTANCE_PVT dependencies on CSI_II_RELATIONSHIPS_H

Line 3260: ' UNION SELECT b.subject_id FROM csi_ii_relationships_h a, csi_ii_relationships 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 '||
3261: ' WHERE a.relationship_id = b.relationship_id AND a.transaction_id = :p_transaction_id '||
3262: ' UNION SELECT a.instance_id FROM csi_i_org_assignments a, csi_i_org_assignments_h b '||
3263: ' WHERE a.instance_ou_id = b.instance_ou_id and b.transaction_id = :p_transaction_id '||
3264: ' UNION SELECT a.instance_id FROM csi_i_pricing_attribs a , csi_i_pricing_attribs_h b '||

Line 10748: FROM CSI_II_RELATIONSHIPS_H CIRH, CSI_II_RELATIONSHIPS CIR

10744: AND INSTANCE_ID=p_ins_id AND TRANSACTION_ID<>p_txn_id
10745: UNION ALL
10746:
10747: SELECT CIRH.TRANSACTION_ID TRANSACTION_ID, CIR.SUBJECT_ID INSTANCE_ID
10748: FROM CSI_II_RELATIONSHIPS_H CIRH, CSI_II_RELATIONSHIPS CIR
10749: WHERE CIRH.RELATIONSHIP_ID = CIR.RELATIONSHIP_ID
10750: AND subject_ID=p_ins_id AND TRANSACTION_ID<>p_txn_id
10751: UNION ALL
10752:

Line 10754: FROM CSI_II_RELATIONSHIPS_H CIRH, CSI_II_RELATIONSHIPS CIR

10750: AND subject_ID=p_ins_id AND TRANSACTION_ID<>p_txn_id
10751: UNION ALL
10752:
10753: SELECT CIRH.TRANSACTION_ID TRANSACTION_ID, CIR.OBJECT_ID INSTANCE_ID
10754: FROM CSI_II_RELATIONSHIPS_H CIRH, CSI_II_RELATIONSHIPS CIR
10755: WHERE CIRH.RELATIONSHIP_ID = CIR.RELATIONSHIP_ID
10756: AND object_ID=p_ins_id AND TRANSACTION_ID<>p_txn_id
10757: UNION ALL
10758: