315: into l_name
316: from fa_book_controls bc
317: , fa_fiscal_year fy
318: , fa_calendar_types ct
319: , fa_calendar_periods cp
320: , fa_adjustments_t fat
321: where bc.book_type_code = i.book
322: and fat.batch_id = p_batch_id
323: and fat.asset_number = i.anum
374: from fa_books bks
375: , fa_book_controls bc
376: , fa_fiscal_year fy
377: , fa_calendar_types ct
378: , fa_calendar_periods cp
379: where bc.book_type_code = i.book
380: and bks.asset_id = i.aid
381: and bc.book_type_code = bks.book_type_code
382: and bc.deprn_calendar = ct.calendar_type