DBA Data[Home] [Help]

APPS.OKL_CREATE_KLE_PVT dependencies on FA_BOOKS

Line 12664: from fa_books fb,

12660: --cursor to get nbv for each book
12661: CURSOR l_nbv_csr (p_book_type_code varchar2,
12662: p_asset_id number) IS
12663: Select (fb.cost - fds.deprn_reserve) nbv
12664: from fa_books fb,
12665: fa_deprn_periods fdp,
12666: fa_deprn_summary fds
12667: where fb.book_type_code = p_book_type_code
12668: and fb.asset_id = p_asset_id

Line 16369: from fa_books fab,

16365: l_orig_cle_rec l_orig_cle_csr%ROWTYPE;
16366:
16367: cursor l_fbk_csr (p_asset_id in number) is
16368: select fab.book_type_code
16369: from fa_books fab,
16370: fa_book_controls fbc
16371: where fab.asset_id = p_asset_id
16372: and fab.transaction_header_id_out is null
16373: and fab.book_type_code = fbc.book_type_code