DBA Data[Home] [Help]

APPS.OKL_FA_AMOUNTS_PVT dependencies on FA_BOOKS

Line 74: from FA_BOOKS

70: original_cost,
71: salvage_value,
72: recoverable_cost,
73: adjusted_recoverable_cost
74: from FA_BOOKS
75: where asset_id = assetid
76: and book_type_code = bookcode
77: and transaction_header_id_out is null
78: and date_ineffective is null;

Line 281: FROM FA_BOOKS FAB,

277: l_asset_id NUMBER;
278:
279: CURSOR Corp_Book_csr (asstid NUMBER) is
280: SELECT fab.book_type_code
281: FROM FA_BOOKS FAB,
282: FA_BOOK_CONTROLS FBC
283: WHERE fab.book_type_code = fbc.book_type_code
284: AND fbc.book_class = 'CORPORATE'
285: AND fab.asset_id = asstid