DBA Data[Home] [Help]

APPS.OKL_CREATE_KLE_PVT dependencies on FA_BOOKS

Line 12750: from fa_books fb,

12746: --cursor to get nbv for each book
12747: CURSOR l_nbv_csr (p_book_type_code varchar2,
12748: p_asset_id number) IS
12749: Select (fb.cost - fds.deprn_reserve) nbv
12750: from fa_books fb,
12751: fa_deprn_periods fdp,
12752: fa_deprn_summary fds
12753: where fb.book_type_code = p_book_type_code
12754: and fb.asset_id = p_asset_id

Line 16531: from fa_books fab,

16527: l_orig_cle_rec l_orig_cle_csr%ROWTYPE;
16528:
16529: cursor l_fbk_csr (p_asset_id in number) is
16530: select fab.book_type_code
16531: from fa_books fab,
16532: fa_book_controls fbc
16533: where fab.asset_id = p_asset_id
16534: and fab.transaction_header_id_out is null
16535: and fab.book_type_code = fbc.book_type_code