255: dpr_in.prorate_date
256: , dpr_in.asset_type
257: FROM fa_ceiling_types ceilt,
258: fa_methods mt,
259: fa_category_books cb,
260: fa_books bk,
261: fa_additions_b ad
262: WHERE cb.book_type_code = X_book
263: AND ad.asset_category_id = cb.category_id
342: dpr_in.prorate_date
343: , dpr_in.asset_type
344: FROM fa_ceiling_types ceilt,
345: fa_methods mt,
346: fa_category_books cb,
347: fa_books_mrc_v bk,
348: fa_additions_b ad
349: WHERE cb.book_type_code = X_book
350: AND ad.asset_category_id = cb.category_id