76: ct.fiscal_year_name,
77: sob.Currency_Code
78: FROM
79: fa_system_controls sc,
80: fa_book_controls bc,
81: gl_sets_of_books sob,
82: fa_calendar_types ct
83: WHERE
84: bc.Book_Type_Code = cp_bookType
211: Cursor C_Tax_Book_Info (p_book in varchar2) Is
212: Select book_type_code
213: from igi_mhc_book_controls
214: where book_type_code in (Select book_type_code
215: from fa_book_controls
216: where book_class ='TAX'
217: and distribution_source_book =p_book)
218: Order by book_type_code;
219:
246: Where book_type_code = p_book;
247:
248: -- bug 3442275, start 1
249: -- get the depreciation aclendar
250: CURSOR c_get_deprn_calendar(cp_book_type_code fa_book_controls.book_type_code%TYPE)
251: IS
252: SELECT deprn_calendar
253: FROM fa_book_controls
254: WHERE book_type_code = cp_book_type_code;
249: -- get the depreciation aclendar
250: CURSOR c_get_deprn_calendar(cp_book_type_code fa_book_controls.book_type_code%TYPE)
251: IS
252: SELECT deprn_calendar
253: FROM fa_book_controls
254: WHERE book_type_code = cp_book_type_code;
255:
256: CURSOR c_get_periods_in_year(cp_calendar_type fa_calendar_types.calendar_type%TYPE)
257: IS
264: SELECT period_num_for_catchup
265: FROM igi_iac_book_controls
266: WHERE book_type_code = cp_book_type_code;
267:
268: l_deprn_calendar fa_book_controls.deprn_calendar%TYPE;
269: l_num_per_fiscal_year fa_calendar_types.number_per_fiscal_year%TYPE;
270: l_iac_reval_period_num igi_iac_book_controls.period_num_for_catchup%TYPE;
271:
272: l_curr_period igi_iac_types.prd_rec;