APPS.IGI_IAC_REVAL_INIT_STRUCT dependencies on FA_BOOKS

Line 433: /* fa information from fa_books and fa_deprn summary from the historic books! */

429: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'error getting information from revaluation rates table'||sqlerrm);
430: return false;
431: end;
432:
433: /* fa information from fa_books and fa_deprn summary from the historic books! */
434: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+populate the fa_asset_info record');
435: declare
436: cursor c_fa_books is
437: select fb.cost

Line 436: cursor c_fa_books is

432:
433: /* fa information from fa_books and fa_deprn summary from the historic books! */
434: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+populate the fa_asset_info record');
435: declare
436: cursor c_fa_books is
437: select fb.cost
438: , fb.adjusted_cost
439: , fb.original_cost
440: , fb.salvage_value

Line 455: from fa_books fb

451: , fds.ytd_deprn
452: , fds.deprn_reserve
453: , fds.deprn_amount
454: , fadd.asset_category_id
455: from fa_books fb
456: , fa_book_controls fbc
457: , fa_deprn_summary fds
458: , fa_additions fadd
459: where fb.book_type_code = fbc.book_type_code

Line 480: for l_b in c_fa_books loop

476: l_dpis_period fa_deprn_periods.period_counter%TYPE;
477: l_current_period fa_deprn_periods.period_counter%TYPE;
478: begin
479:
480: for l_b in c_fa_books loop
481:
482: /*Salavge value correction*/
483: If l_b.Salvage_value <> 0 THen
484: -- resreve

Line 738: /* fa information from fa_books and fa_deprn summary from the historic books! */

734: l_reval_params.reval_prev_rate_info.last_update_date := g_who_date;
735: l_reval_params.reval_prev_rate_info.last_updated_by := g_who_user_id;
736:
737:
738: /* fa information from fa_books and fa_deprn summary from the historic books! */
739: declare
740: cursor c_fa_books is
741: select fb.cost
742: , fb.adjusted_cost

Line 740: cursor c_fa_books is

736:
737:
738: /* fa information from fa_books and fa_deprn summary from the historic books! */
739: declare
740: cursor c_fa_books is
741: select fb.cost
742: , fb.adjusted_cost
743: , fb.original_cost
744: , fb.salvage_value

Line 759: from fa_books fb

755: , fds.ytd_deprn
756: , fds.deprn_reserve
757: , fds.deprn_amount
758: , fadd.asset_category_id
759: from fa_books fb
760: , fa_book_controls fbc
761: , fa_deprn_summary fds
762: , fa_additions fadd
763: where fb.book_type_code = fbc.book_type_code

Line 783: for l_b in c_fa_books loop

779: l_dpis_period fa_deprn_periods.period_counter%TYPE;
780: l_current_period fa_deprn_periods.period_counter%TYPE;
781:
782: begin
783: for l_b in c_fa_books loop
784:
785: /*Salavge value correction*/
786: -- resreve
787: If l_b.Salvage_value <> 0 THen