APPS.OKL_ACCRUAL_SEC_PVT dependencies on OKC_LINE_STYLES_B

Line 217: okc_line_styles_b lseb_rv

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
221: AND lseb_rv.lty_code = 'REVENUE_SHARE'

Line 1548: ,OKC_LINE_STYLES_B lseb

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';
1552:

Line 1560: ,OKC_LINE_STYLES_B lseb

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
1564: AND lseb.lty_code = 'REVENUE_SHARE'

Line 3248: okc_line_styles_b lse,

3244: tl.item_description,
3245: tl.name,
3246: sts.ste_code
3247: FROM okl_k_lines_full_v kle,
3248: okc_line_styles_b lse,
3249: okc_k_lines_tl tl,
3250: okc_statuses_b sts
3251: WHERE kle.lse_id = lse.id
3252: AND lse.lty_code = lnetype

Line 3272: okc_line_styles_b lse,

3268: tl.name,
3269: sts.ste_code,
3270: lse.lty_code
3271: FROM okl_k_lines_full_v kle,
3272: okc_line_styles_b lse,
3273: okc_k_lines_tl tl,
3274: okc_statuses_b sts
3275: WHERE kle.lse_id = lse.id
3276: AND tl.id = kle.id

Line 3294: okc_line_styles_b lse

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
3297: AND okc.id = kle.id
3298: AND lty_code = 'LINK_FEE_ASSET';