DBA Data[Home] [Help]

APPS.OKL_ACCRUAL_DEPRN_ADJ_PVT dependencies on OKL_STRM_TYPE_B

Line 334: okl_strm_type_b styb_rv,

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
338: AND cles_iv.lse_id = lseb_iv.id

Line 356: FROM OKL_STRM_TYPE_B

352:
353: -- Cursor to get sty id
354: CURSOR sty_id_csr IS
355: SELECT id
356: FROM OKL_STRM_TYPE_B
357: WHERE code = 'RENT';
358:
359: -- cursor to select agreement number
360: CURSOR agr_num_csr(p_agr_id NUMBER) IS