APPS.OKL_ACCRUAL_DEPRN_ADJ_PVT dependencies on OKC_LINE_STYLES_B

Line 292: OKC_LINE_STYLES_B cls,

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,
296: FA_CATEGORIES_B fcb,

Line 333: okc_line_styles_b lseb_rv,

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
337: WHERE cles_iv.dnz_chr_id = p_inv_id

Line 336: okc_line_styles_b lseb_iv

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'
340: AND cles_rv.cle_id = cles_iv.id