APPS.OKL_CONTRACT_PVT dependencies on OKC_K_PARTY_ROLES_B

Line 4452: -- okc_k_party_roles_b and okl_k_party_roles

4448: l_cplv_tbl_in(1).ID := rec.id;
4449:
4450: --Bug# 4558486: Changed call to okl_k_party_roles_pvt api
4451: -- to delete records in tables
4452: -- okc_k_party_roles_b and okl_k_party_roles
4453:
4454: l_kplv_tbl_in(1).ID := l_cplv_tbl_in(1).ID;
4455: OKL_K_PARTY_ROLES_PVT.DELETE_K_PARTY_ROLE (
4456: p_api_version => p_api_version,

Line 7373: OKC_K_PARTY_ROLES_B cplb

7369: --cursor to get party payment details for line
7370: CURSOR l_get_pyd_csr (p_kle_id IN NUMBER) is
7371: Select pyd.id
7372: FROM OKL_PARTY_PAYMENT_DTLS pyd,
7373: OKC_K_PARTY_ROLES_B cplb
7374: WHERE pyd.cpl_id = cplb.id
7375: AND nvl(cplb.cle_id,-9999) = p_kle_id;
7376:
7377: l_pyd_id OKL_PARTY_PAYMENT_DTLS.ID%TYPE;

Line 7387: okc_k_party_roles_b cpl

7383: CURSOR l_kpl_csr(p_kle_id IN NUMBER,
7384: p_khr_id IN NUMBER) is
7385: SELECT kpl.id
7386: FROM okl_k_party_roles kpl,
7387: okc_k_party_roles_b cpl
7388: WHERE kpl.id = cpl.id
7389: AND cpl.cle_id = p_kle_id
7390: AND cpl.dnz_chr_id = p_khr_id;
7391:

Line 8222: OKC_K_PARTY_ROLES_B cplb

8218: --cursor to get party payment details for line
8219: CURSOR l_get_pyd_csr (p_kle_id IN NUMBER) is
8220: Select pyd.id
8221: FROM OKL_PARTY_PAYMENT_DTLS pyd,
8222: OKC_K_PARTY_ROLES_B cplb
8223: WHERE pyd.cpl_id = cplb.id
8224: AND nvl(cplb.cle_id,-9999) = p_kle_id;
8225:
8226: l_pyd_id OKL_PARTY_PAYMENT_DTLS.ID%TYPE;

Line 8247: okc_k_party_roles_b cpl

8243: CURSOR l_kpl_csr(p_kle_id IN NUMBER,
8244: p_khr_id IN NUMBER) is
8245: SELECT kpl.id
8246: FROM okl_k_party_roles kpl,
8247: okc_k_party_roles_b cpl
8248: WHERE kpl.id = cpl.id
8249: AND cpl.cle_id = p_kle_id
8250: AND cpl.dnz_chr_id = p_khr_id;
8251: