306: , fb.book_type_code
307: , iah.parent_hierarchy_id
308: , iah.hierarchy_rule_Set_id
309: from fa_additions fa
310: , fa_books fb
311: , fa_asset_hierarchy iah
312: where fa.asset_id = p_asset_id
313: and fa.asset_id = fb.asset_id
314: and fb.book_type_code = x_book_type_code
331: , fa.lease_id
332: , fb.life_in_months
333: , fb.book_type_code
334: from fa_additions fa
335: , fa_books fb
336: , fa_asset_hierarchy iah
337: where fa.asset_category_id = to_number(x_src_entity_value)
338: and fa.asset_id = fb.asset_id
339: and fb.book_type_code = x_book_type_code
356: , fa.lease_id
357: , fb.life_in_months
358: , fb.book_type_code
359: from fa_additions fa
360: , fa_books fb
361: , fa_asset_hierarchy iah
362: where fa.lease_id = to_number(x_src_entity_value)
363: and fa.asset_id = fb.asset_id
364: and fb.date_ineffective is null
378: , fb.book_type_code
379: , iah.parent_hierarchy_id
380: , iah.hierarchy_rule_Set_id
381: from fa_additions fa
382: , fa_books fb
383: , fa_asset_hierarchy iah
384: where fa.asset_id = to_number(x_src_entity_value)
385: and fa.asset_id = fb.asset_id
386: and fb.date_ineffective is null