APPS.OKL_CS_TRANSACTIONS_PVT dependencies on HZ_PARTIES

Line 484: FROM hz_parties hzp, okc_k_party_roles_b cpl

480: x_msg_count OUT NOCOPY NUMBER,
481: x_msg_data OUT NOCOPY VARCHAR2) IS
482:
483: CURSOR c_email IS SELECT email_address
484: FROM hz_parties hzp, okc_k_party_roles_b cpl
485: WHERE cpl.dnz_chr_id = p_khr_id
486: AND cpl.jtot_object1_code = 'OKX_PARTY'
487: AND cpl.rle_code = 'PRIVATE_LABEL'
488: AND cpl.object1_id1 = hzp.party_id;