APPS.OKL_DEAL_CREAT_PVT dependencies on OKC_CONTACTS

Line 8435: from okc_k_party_roles_b cpl, okc_contacts ctc

8431:
8432: CURSOR l_contact_csr IS
8433: --Start modified abhsaxen for performance SQLID 20563327
8434: select ctc.id,ctc.object1_id1,ctc.object1_id2,ctc.jtot_object1_code
8435: from okc_k_party_roles_b cpl, okc_contacts ctc
8436: where cpl.id = ctc.cpl_id
8437: and cpl.rle_code = 'LESSOR'
8438: and ctc.cro_code = 'SALESPERSON'
8439: and cpl.chr_id = p_durv_rec.chr_id