APPS.OKL_ACCRUAL_SEC_PVT dependencies on OKC_LINE_STYLES_B

Line 215: okc_line_styles_b lseb_rv

211: IS
212: SELECT kleb_rv.percent_stake percent_stake
213: FROM okl_k_lines kleb_rv,
214: okc_k_lines_b cles_rv,
215: okc_line_styles_b lseb_rv
216: WHERE
217: cles_rv.dnz_chr_id = p_inv_id
218: AND cles_rv.lse_id = lseb_rv.id
219: AND lseb_rv.lty_code = 'REVENUE_SHARE'

Line 1083: ,OKC_LINE_STYLES_B lseb

1079: CURSOR get_investors_csr(p_khr_id IN NUMBER)
1080: IS
1081: SELECT clet.id id
1082: FROM OKC_K_LINES_B clet
1083: ,OKC_LINE_STYLES_B lseb
1084: WHERE clet.dnz_chr_id = p_khr_id
1085: AND clet.lse_id = lseb.id
1086: AND lseb.lty_code = 'INVESTMENT';
1087:

Line 1095: ,OKC_LINE_STYLES_B lseb

1091: IS
1092: SELECT kleb.percent_stake percent_stake
1093: FROM OKL_K_LINES kleb
1094: ,OKC_K_LINES_B cles
1095: ,OKC_LINE_STYLES_B lseb
1096: WHERE kleb.id = cles.id
1097: AND cles.cle_id = p_tl_id
1098: AND cles.lse_id = lseb.id
1099: AND lseb.lty_code = 'REVENUE_SHARE'

Line 2084: okc_line_styles_b lse,

2080: tl.item_description,
2081: tl.name,
2082: sts.ste_code
2083: FROM okl_k_lines_full_v kle,
2084: okc_line_styles_b lse,
2085: okc_k_lines_tl tl,
2086: okc_statuses_b sts
2087: WHERE kle.lse_id = lse.id
2088: AND lse.lty_code = lnetype

Line 2108: okc_line_styles_b lse,

2104: tl.name,
2105: sts.ste_code,
2106: lse.lty_code
2107: FROM okl_k_lines_full_v kle,
2108: okc_line_styles_b lse,
2109: okc_k_lines_tl tl,
2110: okc_statuses_b sts
2111: WHERE kle.lse_id = lse.id
2112: AND tl.id = kle.id

Line 2130: okc_line_styles_b lse

2126: kle.amount amount,
2127: lse.lty_code lty_code
2128: FROM okc_k_lines_b okc,
2129: okl_k_lines kle ,
2130: okc_line_styles_b lse
2131: WHERE okc.cle_id = cleId
2132: AND okc.lse_id = lse.id
2133: AND okc.id = kle.id
2134: AND lty_code = 'LINK_FEE_ASSET';