APPS.FA_AMORT_PKG dependencies on FA_DEPRN_SUMMARY

Line 380: -- from fa_deprn_summary

376: and transaction_header_id = X_fin_info_ptr.transaction_id);
377: -- Bug4560593: Commenting out
378: -- where not exists
379: -- (select 'x'
380: -- from fa_deprn_summary
381: -- where asset_id = X_fin_info_ptr.asset_id
382: -- and book_type_code = X_fin_info_ptr.book
383: -- and deprn_amount <> 0
384: -- and deprn_source_code = 'DEPRN'

Line 407: -- This is to determine whether BOOKS row of FA_DEPRN_SUMMARY

403:
404: --
405: -- This is to check whether the backdated transaction
406: -- is dated in the same fy as fy of addition.
407: -- This is to determine whether BOOKS row of FA_DEPRN_SUMMARY
408: -- can be used or not
409: --
410: cursor c_check_fiscal_year (c_thid number) is
411: select 1

Line 433: from fa_deprn_summary

429: --
430: cursor c_get_reserve is
431: select deprn_reserve - ytd_deprn
432: , bonus_deprn_reserve - bonus_ytd_deprn
433: from fa_deprn_summary
434: where book_type_code = X_fin_info_ptr.book
435: and asset_id = X_fin_info_ptr.asset_id
436: and deprn_source_code = 'BOOKS';
437:

Line 999: -- from fa_deprn_summary_mrc_v

995: -- if x_mrc_sob_type_code = 'R' then
996: -- select deprn_reserve, bonus_deprn_reserve, ytd_deprn
997: -- into deprn_summary.deprn_rsv, deprn_summary.bonus_deprn_rsv,
998: -- deprn_summary.ytd_deprn
999: -- from fa_deprn_summary_mrc_v
1000: -- where asset_id = X_fin_info_ptr.asset_id
1001: -- and book_type_code = X_fin_info_ptr.book
1002: -- and deprn_source_code = 'BOOKS';
1003: -- else

Line 1007: -- from fa_deprn_summary

1003: -- else
1004: -- select deprn_reserve, bonus_deprn_reserve, ytd_deprn
1005: -- into deprn_summary.deprn_rsv, deprn_summary.bonus_deprn_rsv,
1006: -- deprn_summary.ytd_deprn
1007: -- from fa_deprn_summary
1008: -- where asset_id = X_fin_info_ptr.asset_id
1009: -- and book_type_code = X_fin_info_ptr.book
1010: -- and deprn_source_code = 'BOOKS';
1011: -- end if;

Line 1032: -- Get reserve from FA_DEPRN_SUMMARY. User RSV - YTD of BOOKS row

1028: if (h_add_txn_id > 0) then
1029:
1030: --
1031: -- Bug3281141:
1032: -- Get reserve from FA_DEPRN_SUMMARY. User RSV - YTD of BOOKS row
1033: -- if this is backdated to the beginning of fy and addition was
1034: -- performed in the same fy.
1035: --
1036: open c_check_fiscal_year (h_add_txn_id);