APPS.OKL_ACCRUAL_SEC_PVT dependencies on OKC_K_LINES_B

Line 214: okc_k_lines_b cles_rv,

210: CURSOR get_revenue_share_csr(p_inv_id NUMBER, p_stream_type_subclass VARCHAR2)
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

Line 1082: FROM OKC_K_LINES_B clet

1078: -- list of all investors for the agreement
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';

Line 1094: ,OKC_K_LINES_B cles

1090: CURSOR get_revenue_share_csr(p_tl_id NUMBER, p_stream_type_subclass VARCHAR2)
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

Line 2128: FROM okc_k_lines_b okc,

2124: okc.dnz_chr_id dnz_chr_id,
2125: kle.capital_amount capital_amount,
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