APPS.OKL_CONTRACT_PVT dependencies on OKL_PARTY_PAYMENT_DTLS

Line 7372: FROM OKL_PARTY_PAYMENT_DTLS pyd,

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

Line 7377: l_pyd_id OKL_PARTY_PAYMENT_DTLS.ID%TYPE;

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;
7378:
7379: l_ppydv_tbl OKL_PYD_PVT.ppydv_tbl_type;
7380: i number default 0;
7381:

Line 8221: FROM OKL_PARTY_PAYMENT_DTLS pyd,

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

Line 8226: l_pyd_id OKL_PARTY_PAYMENT_DTLS.ID%TYPE;

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;
8227:
8228: l_ppydv_tbl OKL_PYD_PVT.ppydv_tbl_type;
8229: k number default 0;
8230: --Bug# 3143522