APPS.IGI_IAC_CATCHUP_PKG dependencies on FA_BOOKS

Line 96: FROM fa_books

92: period_counter_fully_retired,
93: transaction_header_id_in,
94: life_in_months,
95: add_months(date_placed_in_service,life_in_months) last_date
96: FROM fa_books
97: WHERE book_type_code = p_book_type_code
98: AND asset_id = p_asset_id
99: AND transaction_header_id_out IS NULL;
100:

Line 548: FROM fa_books

544: AND nvl(active_flag,'Y') = 'N';
545:
546: cursor c_asset_details_salvage is
547: SELECT life_in_months,salvage_value,rate_adjustment_factor
548: FROM fa_books
549: WHERE book_type_code = p_asset_balance.book_type_code
550: AND asset_id = p_asset_balance.asset_id
551: AND date_ineffective is NULL ;
552:

Line 1447: FROM fa_books b, fa_book_controls c

1443: 0 pys_deprn_reserve,
1444: 0 deprn_amount,
1445: deprn_start_date,
1446: depreciate_flag
1447: FROM fa_books b, fa_book_controls c
1448: WHERE b.book_type_code = p_reval_asset_params(1).book_type_code
1449: AND c.book_type_code = p_reval_asset_params(1).book_type_code
1450: AND b.asset_id = p_reval_asset_params(1).asset_id
1451: AND b.transaction_header_id_out IS NULL;