DBA Data[Home] [Help]

APPS.FA_TAX_UPLOAD_PKG dependencies on FA_BOOK_CONTROLS

Line 307: from fa_book_controls fbc

303: cursor l_curr_open_period(p_book_type_code in varchar2
304: )
305: is
306: select fdp.calendar_period_close_date
307: from fa_book_controls fbc
308: ,fa_deprn_periods fdp
309: where fbc.book_type_code = fdp.book_type_code
310: and fdp.period_counter = fbc.last_period_counter+1
311: and fbc.book_type_code = p_book_type_code;

Line 323: ,fa_book_controls fbc

319: ,ffy.fiscal_year
320: ,fcp.period_num
321: ,fct.number_per_fiscal_year
322: from fa_fiscal_year ffy
323: ,fa_book_controls fbc
324: ,fa_calendar_periods fcp
325: ,fa_calendar_types fct
326: where ffy.fiscal_year_name = fbc.fiscal_year_name
327: and ffy.fiscal_year_name = fct.fiscal_year_name