DBA Data[Home] [Help]

APPS.OKL_LOSS_PROV_PVT dependencies on OKC_CONTACT_SOURCES

Line 509: OKC_CONTACT_SOURCES cso,

505: -- 30-Apr-2004. Bug 3596651. Cursor provided by Sarvanan.
506: CURSOR l_salesperson_csr (cp_chr_id IN NUMBER) IS
507: SELECT con.object1_id1
508: FROM OKC_K_HEADERS_B CHR,
509: OKC_CONTACT_SOURCES cso,
510: OKC_K_PARTY_ROLES_B kpr,
511: OKC_CONTACTS con
512: WHERE CHR.id = cp_chr_id
513: AND cso.cro_code = 'SALESPERSON'