APPS.IGI_IAC_CATCHUP_PKG dependencies on FA_BOOKS

Line 113: FROM fa_books

109: period_counter_fully_retired,
110: transaction_header_id_in,
111: life_in_months,
112: add_months(date_placed_in_service,life_in_months) last_date
113: FROM fa_books
114: WHERE book_type_code = p_book_type_code
115: AND asset_id = p_asset_id
116: AND transaction_header_id_out IS NULL;
117:

Line 590: FROM fa_books

586: AND nvl(active_flag,'Y') = 'N';
587:
588: cursor c_asset_details_salvage is
589: SELECT life_in_months,salvage_value,rate_adjustment_factor
590: FROM fa_books
591: WHERE book_type_code = p_asset_balance.book_type_code
592: AND asset_id = p_asset_balance.asset_id
593: AND date_ineffective is NULL ;
594:

Line 1530: FROM fa_books b, fa_book_controls c

1526: 0 pys_deprn_reserve,
1527: 0 deprn_amount,
1528: deprn_start_date,
1529: depreciate_flag
1530: FROM fa_books b, fa_book_controls c
1531: WHERE b.book_type_code = p_reval_asset_params(1).book_type_code
1532: AND c.book_type_code = p_reval_asset_params(1).book_type_code
1533: AND b.asset_id = p_reval_asset_params(1).asset_id
1534: AND b.transaction_header_id_out IS NULL;