APPS.OKL_CS_TRANSACTIONS_PVT dependencies on OKC_K_PARTY_ROLES_B

Line 474: FROM hz_parties hzp, okc_k_party_roles_b cpl

470: x_msg_count OUT NOCOPY NUMBER,
471: x_msg_data OUT NOCOPY VARCHAR2) IS
472:
473: CURSOR c_email IS SELECT email_address
474: FROM hz_parties hzp, okc_k_party_roles_b cpl
475: WHERE cpl.dnz_chr_id = p_khr_id
476: AND cpl.jtot_object1_code = 'OKX_PARTY'
477: AND cpl.rle_code = 'PRIVATE_LABEL'
478: AND cpl.object1_id1 = hzp.party_id;