APPS.OKL_ACCRUAL_DEPRN_ADJ_PVT dependencies on OKC_K_LINES_B

Line 291: OKC_K_LINES_B cle,

287: SUM(fds.deprn_amount) deprn_amount
288: FROM
289: OKL_TRX_CONTRACTS trx,
290: OKC_K_ITEMS cli,
291: OKC_K_LINES_B cle,
292: OKC_LINE_STYLES_B cls,
293: FA_BOOKS fab,
294: FA_ADDITIONS_B fad,
295: FA_BOOK_CONTROLS fbc,

Line 332: okc_k_lines_b cles_rv,

328: -- Bug 3130551
329: CURSOR get_revenue_share_csr(p_inv_id NUMBER) IS
330: SELECT SUM(kleb_rv.percent_stake) percent_stake
331: FROM okl_k_lines kleb_rv,
332: okc_k_lines_b cles_rv,
333: okc_line_styles_b lseb_rv,
334: okl_strm_type_b styb_rv,
335: okc_k_lines_b cles_iv,
336: okc_line_styles_b lseb_iv

Line 335: okc_k_lines_b cles_iv,

331: FROM okl_k_lines kleb_rv,
332: okc_k_lines_b cles_rv,
333: okc_line_styles_b lseb_rv,
334: okl_strm_type_b styb_rv,
335: okc_k_lines_b cles_iv,
336: okc_line_styles_b lseb_iv
337: WHERE cles_iv.dnz_chr_id = p_inv_id
338: AND cles_iv.lse_id = lseb_iv.id
339: AND lseb_iv.lty_code = 'INVESTMENT'