APPS.OKL_MISC_TRANS_PVT dependencies on OKC_CONTACTS

Line 660: from okc_contacts ct,

656: l_org_id NUMBER;
657:
658: Cursor sales_csr(v_khr_id NUMBER) IS
659: SELECT ct.object1_id1 id
660: from okc_contacts ct,
661: okc_contact_sources csrc,
662: okc_k_party_roles_b pty,
663: okc_k_headers_b chr
664: where ct.cpl_id = pty.id

Line 676: l_sales_rep OKC_CONTACTS.object1_id1%TYPE;

672: and pty.dnz_chr_id = chr.id
673: and pty.chr_id = chr.id
674: and chr.id = v_khr_id;
675:
676: l_sales_rep OKC_CONTACTS.object1_id1%TYPE;
677:
678: CURSOR trx_csr IS
679: SELECT cust_trx_type_id
680: FROM ra_cust_trx_types