DBA Data[Home] [Help]

APPS.FA_CIP_PUB dependencies on FA_BOOKS

Line 276: FROM fa_books bks,

272:
273: -- Bug 5475276 Cursor to get the book_type_code
274: CURSOR c_corp_book( p_asset_id number ) IS
275: SELECT bc.book_type_code
276: FROM fa_books bks,
277: fa_book_controls bc
278: WHERE bks.book_type_code = bc.distribution_source_book
279: AND bks.book_type_code = bc.book_type_code
280: AND bks.asset_id = p_asset_id

Line 576: from fa_books

572: l_asset_fin_rec.group_asset_id,
573: l_asset_fin_rec.salvage_type,
574: l_asset_fin_rec.percent_salvage_value,
575: l_asset_fin_rec.salvage_value
576: from fa_books
577: where asset_id = px_asset_hdr_rec.asset_id
578: and book_type_code = fa_cache_pkg.fazcbc_record.distribution_source_book
579: and transaction_header_id_in = l_corp_thid;
580: