DBA Data[Home] [Help]

APPS.FA_GAINLOSS_UND_PKG dependencies on FA_BOOKS_MRC_V

Line 1352: from fa_books_mrc_v

1348: else -- for reporting
1349: -- MRC
1350: /*select nvl(rate_in_use,0)
1351: into l_rate_in_use
1352: from fa_books_mrc_v
1353: where asset_id = ret.asset_id
1354: and book_type_code = ret.book
1355: and transaction_header_id_out is null;*/
1356:

Line 1515: INSERT into fa_books_mrc_v

1511: WHERE asset_id = ret.asset_id
1512: AND book_type_code = ret.book
1513: AND transaction_header_id_out = h_rethdrout;
1514: else -- for reporting
1515: INSERT into fa_books_mrc_v
1516: (book_type_Code, asset_id, date_placed_in_service,
1517: transaction_header_id_in, date_effective, transaction_header_id_out,
1518: date_ineffective, deprn_start_date, deprn_method_code,
1519: life_in_months, rate_adjustment_factor, adjusted_cost, cost,

Line 1626: FROM fa_books_mrc_v

1622: , eop_formula_factor
1623: , exclude_proceeds_from_basis
1624: , retirement_deprn_option
1625: , p_asset_fin_rec_new.adjusted_recoverable_cost /* fix for bug 3149457 */
1626: FROM fa_books_mrc_v
1627: WHERE asset_id = ret.asset_id
1628: AND book_type_code = ret.book
1629: AND transaction_header_id_out = h_rethdrout;
1630: end if;

Line 1661: /*update fa_books_mrc_v

1657: end if;
1658:
1659: else -- For Reporting
1660: -- TO DO -- MRC
1661: /*update fa_books_mrc_v
1662: set rate_in_use = l_rate_in_use
1663: where asset_id = ret.asset_id
1664: and book_type_code = ret.Book
1665: and transaction_header_id_out is null;*/