DBA Data[Home] [Help]

APPS.JA_CN_PS_FA_MI_EXP_PKG dependencies on FA_TRANSACTION_HISTORY_BOOKS_V

Line 312: FROM fa_transaction_history_books_v

308: lv_change_content(1) := 'Current Cost: ';
309: lv_before(1) := 0;
310: SELECT current_cost
311: INTO lv_after(1)
312: FROM fa_transaction_history_books_v
313: WHERE (key = v_row.transaction_header_id)
314: AND transaction_type = 'Addition';
315: lv_after(1) := ja_cn_utility.
316: get_rounding_value( to_number(lv_after(1)) * ln_factor

Line 432: FROM fa_transaction_history_books_v

428: SELECT current_cost
429: INTO lv_before(1)
430: FROM (
431: SELECT current_cost
432: FROM fa_transaction_history_books_v
433: WHERE key = v_row.transaction_header_id
434: ORDER BY transaction_header_id_in)
435: WHERE ROWNUM = 1;
436:

Line 441: FROM fa_transaction_history_books_v

437: SELECT current_cost
438: INTO lv_after(1)
439: FROM (
440: SELECT current_cost
441: FROM fa_transaction_history_books_v
442: WHERE key = v_row.transaction_header_id
443: ORDER BY transaction_header_id_in DESC)
444: WHERE ROWNUM = 1;
445: lv_before(1) := ja_cn_utility.get_rounding_value

Line 550: FROM fa_transaction_history_books_v

546: date_placed_in_service,
547: depreciate_flag,
548: bonus_rule,
549: ceiling_name
550: FROM fa_transaction_history_books_v
551: WHERE (key = v_row.transaction_header_id)
552: ORDER BY transaction_header_id_in)
553: WHERE ROWNUM = 1;
554:

Line 586: FROM fa_transaction_history_books_v

582: date_placed_in_service,
583: depreciate_flag,
584: bonus_rule,
585: ceiling_name
586: FROM fa_transaction_history_books_v
587: WHERE (key = v_row.transaction_header_id)
588: ORDER BY transaction_header_id_in DESC)
589: WHERE ROWNUM = 1;
590: lv_before(1) := Ja_Cn_Utility.get_rounding_value