APPS.FA_AMORT_PKG dependencies on FA_DEPRN_SUMMARY

Line 399: from fa_deprn_summary

395: select 'Y' -- 'Y' if the current period of the asset is period of addition.
396: from dual
397: where not exists
398: (select 'x'
399: from fa_deprn_summary
400: where asset_id = X_fin_info_ptr.asset_id
401: and book_type_code = X_fin_info_ptr.book
402: and deprn_amount <> 0
403: and deprn_source_code = 'DEPRN'

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

421:
422: --
423: -- This is to check whether the backdated transaction
424: -- is dated in the same fy as fy of addition.
425: -- This is to determine whether BOOKS row of FA_DEPRN_SUMMARY
426: -- can be used or not
427: --
428: cursor c_check_fiscal_year (c_thid number) is
429: select 1

Line 451: from fa_deprn_summary

447: --
448: cursor c_get_reserve is
449: select deprn_reserve - ytd_deprn
450: , bonus_deprn_reserve - bonus_ytd_deprn
451: from fa_deprn_summary
452: where book_type_code = X_fin_info_ptr.book
453: and asset_id = X_fin_info_ptr.asset_id
454: and deprn_source_code = 'BOOKS';
455:

Line 459: from fa_deprn_summary_mrc_v

455:
456: cursor c_get_mc_reserve is
457: select deprn_reserve - ytd_deprn
458: , bonus_deprn_reserve - bonus_ytd_deprn
459: from fa_deprn_summary_mrc_v
460: where book_type_code = X_fin_info_ptr.book
461: and asset_id = X_fin_info_ptr.asset_id
462: and deprn_source_code = 'BOOKS';
463:

Line 1029: from fa_deprn_summary_mrc_v

1025: if x_mrc_sob_type_code = 'R' then
1026: select deprn_reserve, bonus_deprn_reserve, ytd_deprn
1027: into deprn_summary.deprn_rsv, deprn_summary.bonus_deprn_rsv,
1028: deprn_summary.ytd_deprn
1029: from fa_deprn_summary_mrc_v
1030: where asset_id = X_fin_info_ptr.asset_id
1031: and book_type_code = X_fin_info_ptr.book
1032: and deprn_source_code = 'BOOKS';
1033: else

Line 1037: from fa_deprn_summary

1033: else
1034: select deprn_reserve, bonus_deprn_reserve, ytd_deprn
1035: into deprn_summary.deprn_rsv, deprn_summary.bonus_deprn_rsv,
1036: deprn_summary.ytd_deprn
1037: from fa_deprn_summary
1038: where asset_id = X_fin_info_ptr.asset_id
1039: and book_type_code = X_fin_info_ptr.book
1040: and deprn_source_code = 'BOOKS';
1041: end if;

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

1058: if (h_add_txn_id > 0) then
1059:
1060: --
1061: -- Bug3281141:
1062: -- Get reserve from FA_DEPRN_SUMMARY. User RSV - YTD of BOOKS row
1063: -- if this is backdated to the beginning of fy and addition was
1064: -- performed in the same fy.
1065: --
1066: open c_check_fiscal_year (h_add_txn_id);