APPS.OKL_DEAL_CREATE_PUB dependencies on OKC_CONTACTS

Line 8164: from okc_k_party_roles_b cpl, okc_contacts ctc

8160:
8161: CURSOR l_contact_csr IS
8162: --Start modified abhsaxen for performance SQLID 20563327
8163: select ctc.id,ctc.object1_id1,ctc.object1_id2,ctc.jtot_object1_code
8164: from okc_k_party_roles_b cpl, okc_contacts ctc
8165: where cpl.id = ctc.cpl_id
8166: and cpl.rle_code = 'LESSOR'
8167: and ctc.cro_code = 'SALESPERSON'
8168: and cpl.chr_id = p_durv_rec.chr_id