1543: , okc_k_lines_b cle
1544: , okc_k_lines_b cle_inv
1545: , okc_k_party_roles_b cpl
1546: , okc_k_party_roles_b cpl_inv
1547: , hz_parties hz
1548: WHERE khr.id = p_khr_id
1549: AND cle.dnz_chr_id = khr.id
1550: AND cle_inv.dnz_chr_id = khr.id
1551: AND cpl.rle_code = 'INVESTOR'