APPS.OKL_CONTRACT_PVT dependencies on OKL_PARTY_PAYMENT_DTLS

Line 7474: FROM OKL_PARTY_PAYMENT_DTLS pyd,

7470:
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:

Line 7479: l_pyd_id OKL_PARTY_PAYMENT_DTLS.ID%TYPE;

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;
7480:
7481: l_ppydv_tbl OKL_PYD_PVT.ppydv_tbl_type;
7482: i number default 0;
7483:

Line 8323: FROM OKL_PARTY_PAYMENT_DTLS pyd,

8319:
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:

Line 8328: l_pyd_id OKL_PARTY_PAYMENT_DTLS.ID%TYPE;

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;
8329:
8330: l_ppydv_tbl OKL_PYD_PVT.ppydv_tbl_type;
8331: k number default 0;
8332: --Bug# 3143522