APPS.FA_IMPAIRMENT_POST_PVT dependencies on FA_MC_BOOKS

Line 270: from fa_mc_books fb,fa_transaction_headers fth

266:
267: /* 12844989 - to set correct old_adj_cost of asset in extended deprn period.*/
268: CURSOR c_mc_get_old_adj_cost IS
269: select fb.ADJUSTED_COST
270: from fa_mc_books fb,fa_transaction_headers fth
271: where fb.asset_id = l_asset_hdr_rec.asset_id
272: and fb. book_type_code = l_asset_hdr_rec.book_type_code
273: and fb.transaction_header_id_in = fth.transaction_header_id
274: and fb.book_type_code = fth.book_type_code

Line 1712: UPDATE FA_MC_BOOKS

1708: fa_debug_pkg.add(l_calling_fn,'Deactivating ', 'FA_BOOKS_MRC_V', p_log_level_rec => p_log_level_rec);
1709: end if;
1710:
1711: FORALL i in 1..t_request_id.count
1712: UPDATE FA_MC_BOOKS
1713: SET DATE_INEFFECTIVE = t_creation_date(i)
1714: , TRANSACTION_HEADER_ID_OUT = t_thid(i)
1715: WHERE ASSET_ID = t_asset_id(i)
1716: AND BOOK_TYPE_CODE = p_book_type_code

Line 1743: INSERT INTO FA_MC_BOOKS( SET_OF_BOOKS_ID

1739: fa_debug_pkg.add(l_calling_fn,'Inserting record into ', 'FA_BOOKS_MRC_V', p_log_level_rec => p_log_level_rec);
1740: end if;
1741:
1742: FORALL i in 1..t_request_id.count
1743: INSERT INTO FA_MC_BOOKS( SET_OF_BOOKS_ID
1744: , BOOK_TYPE_CODE
1745: , ASSET_ID
1746: , DATE_PLACED_IN_SERVICE
1747: , DATE_EFFECTIVE

Line 1973: FROM FA_MC_BOOKS

1969: , SUPER_GROUP_ID
1970: , OVER_DEPRECIATE_OPTION
1971: , DISABLED_FLAG
1972: , CASH_GENERATING_UNIT_ID
1973: FROM FA_MC_BOOKS
1974: WHERE TRANSACTION_HEADER_ID_IN = t_old_thid(i)
1975: and SET_OF_BOOKS_ID = p_set_of_books_id ;
1976:
1977: else