APPS.IGI_IAC_REVAL_UTILITIES dependencies on FA_BOOKS

Line 102: from fa_calendar_types ct , fa_book_controls bc , fa_books bk

98: begin
99: l_path_name := g_path||'last_period_counter';
100: select ct.calendar_type , ct.number_per_fiscal_year , bk.life_in_months
101: into l_calendar_type , l_number_per_fiscal_year , l_life_in_months
102: from fa_calendar_types ct , fa_book_controls bc , fa_books bk
103: where ct.calendar_type = bc.deprn_calendar
104: and bk.book_type_code = p_book_type_code
105: and bk.date_ineffective is null
106: and bk.asset_id = p_asset_id

Line 132: CURSOR c_get_deprn_calendar (p_book_type_code fa_books.book_type_code%type) IS

128: )
129: return boolean is
130:
131: /* Bug 2763328 sekhar */
132: CURSOR c_get_deprn_calendar (p_book_type_code fa_books.book_type_code%type) IS
133: SELECT deprn_calendar
134: FROM fa_book_controls
135: WHERE book_type_code like p_book_type_code;
136:

Line 660: FROM fa_books fb

656: SELECT fb.date_placed_in_service,
657: fb.period_counter_fully_reserved,
658: fb.life_in_months,
659: fb.depreciate_flag
660: FROM fa_books fb
661: WHERE fb.book_type_code = fp_book_type_code
662: AND fb.asset_id = fp_asset_id
663: AND fb.transaction_header_id_out IS NULL;
664:

Line 878: FROM fa_books fb

874: SELECT fb.date_placed_in_service,
875: fb.period_counter_fully_reserved,
876: fb.life_in_months,
877: fb.depreciate_flag
878: FROM fa_books fb
879: WHERE fb.book_type_code = fp_book_type_code
880: AND fb.asset_id = fp_asset_id
881: AND fb.transaction_header_id_out IS NULL;
882: