DBA Data[Home] [Help]

APPS.CSI_II_RELATIONSHIPS_PVT dependencies on CSI_I_PARTIES

Line 4722: FROM csi_i_parties cp,

4718: ,l_party_tbl(1).contact_flag
4719: ,l_party_tbl(1).relationship_type_code
4720: ,l_account_tbl(1).party_account_id
4721: ,l_account_tbl(1).relationship_type_code
4722: FROM csi_i_parties cp,
4723: csi_ip_accounts ca
4724: WHERE cp.instance_id = p_ii_relationship_rec.object_id
4725: AND cp.instance_party_id = ca.instance_party_id
4726: AND cp.relationship_type_code = 'OWNER'

Line 4740: FROM csi_i_parties

4736: SELECT instance_party_id
4737: ,object_version_number
4738: INTO l_party_tbl(1).instance_party_id
4739: ,l_party_tbl(1).object_version_number
4740: FROM csi_i_parties
4741: WHERE instance_id = p_ii_relationship_rec.subject_id
4742: AND relationship_type_code = 'OWNER';
4743: l_account_tbl(1).instance_party_id := l_party_tbl(1).instance_party_id;
4744: EXCEPTION