1607: , okc_k_lines_b cle
1608: , okc_k_lines_b cle_inv
1609: , okc_k_party_roles_b cpl
1610: , okc_k_party_roles_b cpl_inv
1611: , hz_parties hz
1612: WHERE khr.id = p_khr_id
1613: AND cle.dnz_chr_id = khr.id
1614: AND cle_inv.dnz_chr_id = khr.id
1615: AND cpl.rle_code = 'INVESTOR'