APPS.OKL_ACCRUAL_SEC_PVT dependencies on OKC_K_LINES_B

Line 216: okc_k_lines_b cles_rv,

212: CURSOR get_revenue_share_csr(p_inv_id NUMBER, p_stream_type_subclass VARCHAR2)
213: IS
214: SELECT kleb_rv.percent_stake percent_stake
215: FROM okl_k_lines kleb_rv,
216: okc_k_lines_b cles_rv,
217: okc_line_styles_b lseb_rv
218: WHERE
219: cles_rv.dnz_chr_id = p_inv_id
220: AND cles_rv.lse_id = lseb_rv.id

Line 1547: FROM OKC_K_LINES_B clet

1543: -- list of all investors for the agreement
1544: CURSOR get_investors_csr(p_khr_id IN NUMBER)
1545: IS
1546: SELECT clet.id id
1547: FROM OKC_K_LINES_B clet
1548: ,OKC_LINE_STYLES_B lseb
1549: WHERE clet.dnz_chr_id = p_khr_id
1550: AND clet.lse_id = lseb.id
1551: AND lseb.lty_code = 'INVESTMENT';

Line 1559: ,OKC_K_LINES_B cles

1555: CURSOR get_revenue_share_csr(p_tl_id NUMBER, p_stream_type_subclass VARCHAR2)
1556: IS
1557: SELECT kleb.percent_stake percent_stake
1558: FROM OKL_K_LINES kleb
1559: ,OKC_K_LINES_B cles
1560: ,OKC_LINE_STYLES_B lseb
1561: WHERE kleb.id = cles.id
1562: AND cles.cle_id = p_tl_id
1563: AND cles.lse_id = lseb.id

Line 3292: FROM okc_k_lines_b okc,

3288: okc.dnz_chr_id dnz_chr_id,
3289: kle.capital_amount capital_amount,
3290: kle.amount amount,
3291: lse.lty_code lty_code
3292: FROM okc_k_lines_b okc,
3293: okl_k_lines kle ,
3294: okc_line_styles_b lse
3295: WHERE okc.cle_id = cleId
3296: AND okc.lse_id = lse.id