DBA Data[Home] [Help]

APPS.OKL_LOSS_PROV_PVT dependencies on OKC_K_PARTY_ROLES_B

Line 510: OKC_K_PARTY_ROLES_B kpr,

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'
514: AND cso.rle_code = 'LESSOR'