APPS.OKL_CONTRACT_PVT dependencies on OKC_K_PARTY_ROLES_B

Line 4537: -- okc_k_party_roles_b and okl_k_party_roles

4533: l_cplv_tbl_in(1).ID := rec.id;
4534:
4535: --Bug# 4558486: Changed call to okl_k_party_roles_pvt api
4536: -- to delete records in tables
4537: -- okc_k_party_roles_b and okl_k_party_roles
4538:
4539: l_kplv_tbl_in(1).ID := l_cplv_tbl_in(1).ID;
4540: OKL_K_PARTY_ROLES_PVT.DELETE_K_PARTY_ROLE (
4541: p_api_version => p_api_version,

Line 7475: OKC_K_PARTY_ROLES_B cplb

7471: --cursor to get party payment details for line
7472: CURSOR l_get_pyd_csr (p_kle_id IN NUMBER) is
7473: Select pyd.id
7474: FROM OKL_PARTY_PAYMENT_DTLS pyd,
7475: OKC_K_PARTY_ROLES_B cplb
7476: WHERE pyd.cpl_id = cplb.id
7477: AND nvl(cplb.cle_id,-9999) = p_kle_id;
7478:
7479: l_pyd_id OKL_PARTY_PAYMENT_DTLS.ID%TYPE;

Line 7489: okc_k_party_roles_b cpl

7485: CURSOR l_kpl_csr(p_kle_id IN NUMBER,
7486: p_khr_id IN NUMBER) is
7487: SELECT kpl.id
7488: FROM okl_k_party_roles kpl,
7489: okc_k_party_roles_b cpl
7490: WHERE kpl.id = cpl.id
7491: AND cpl.cle_id = p_kle_id
7492: AND cpl.dnz_chr_id = p_khr_id;
7493:

Line 8324: OKC_K_PARTY_ROLES_B cplb

8320: --cursor to get party payment details for line
8321: CURSOR l_get_pyd_csr (p_kle_id IN NUMBER) is
8322: Select pyd.id
8323: FROM OKL_PARTY_PAYMENT_DTLS pyd,
8324: OKC_K_PARTY_ROLES_B cplb
8325: WHERE pyd.cpl_id = cplb.id
8326: AND nvl(cplb.cle_id,-9999) = p_kle_id;
8327:
8328: l_pyd_id OKL_PARTY_PAYMENT_DTLS.ID%TYPE;

Line 8349: okc_k_party_roles_b cpl

8345: CURSOR l_kpl_csr(p_kle_id IN NUMBER,
8346: p_khr_id IN NUMBER) is
8347: SELECT kpl.id
8348: FROM okl_k_party_roles kpl,
8349: okc_k_party_roles_b cpl
8350: WHERE kpl.id = cpl.id
8351: AND cpl.cle_id = p_kle_id
8352: AND cpl.dnz_chr_id = p_khr_id;
8353: