APPS.JA_CN_FA_MI_EXPORT_PKG dependencies on FA_TRANSACTION_HISTORY_BOOKS_V

Line 286: FROM fa_transaction_history_books_v

282: lv_change_content(1) := 'Current Cost: ';
283: lv_before(1) := 0;
284: SELECT current_cost
285: INTO lv_after(1)
286: FROM fa_transaction_history_books_v
287: WHERE (key = v_row.transaction_header_id)
288: AND transaction_type = 'Addition';
289: lv_after(1) := ja_cn_utility.get_rounding_value(to_number(lv_after(1)) * ln_factor
290: ,pn_legal_entity_id);

Line 400: FROM fa_transaction_history_books_v

396: SELECT current_cost
397: INTO lv_before(1)
398: FROM (
399: SELECT current_cost
400: FROM fa_transaction_history_books_v
401: WHERE key = v_row.transaction_header_id
402: ORDER BY transaction_header_id_in)
403: WHERE ROWNUM = 1;
404:

Line 409: FROM fa_transaction_history_books_v

405: SELECT current_cost
406: INTO lv_after(1)
407: FROM (
408: SELECT current_cost
409: FROM fa_transaction_history_books_v
410: WHERE key = v_row.transaction_header_id
411: ORDER BY transaction_header_id_in DESC)
412: WHERE ROWNUM = 1;
413: lv_before(1) := ja_cn_utility.get_rounding_value(to_number(lv_before(1)) * ln_factor

Line 515: FROM fa_transaction_history_books_v

511: date_placed_in_service,
512: depreciate_flag,
513: bonus_rule,
514: ceiling_name
515: FROM fa_transaction_history_books_v
516: WHERE (key = v_row.transaction_header_id)
517: ORDER BY transaction_header_id_in)
518: WHERE ROWNUM = 1;
519:

Line 551: FROM fa_transaction_history_books_v

547: date_placed_in_service,
548: depreciate_flag,
549: bonus_rule,
550: ceiling_name
551: FROM fa_transaction_history_books_v
552: WHERE (key = v_row.transaction_header_id)
553: ORDER BY transaction_header_id_in DESC)
554: WHERE ROWNUM = 1;
555: lv_before(1) := ja_cn_utility.get_rounding_value(to_number(lv_before(1)) * ln_factor