DBA Data[Home] [Help]

APPS.JL_CO_FA_TA_REVAL_PKG dependencies on GL_SETS_OF_BOOKS

Line 78: x_currency_code gl_sets_of_books.currency_code%TYPE;

74: x_gl_je_source xla_subledgers.je_source_name%TYPE; -- Bug 5136047
75: x_distribution_source_book fa_book_controls.distribution_source_book%TYPE;
76: x_deprn_status fa_book_controls.deprn_status%TYPE;
77: x_je_category_name fa_book_controls.global_attribute13%TYPE;
78: x_currency_code gl_sets_of_books.currency_code%TYPE;
79: x_period_name fa_deprn_periods.period_name%TYPE;
80: x_user_je_source_name gl_je_sources.user_je_source_name%TYPE;
81: x_period_counter fa_book_controls.last_period_counter%TYPE;
82: x_count1 NUMBER;

Line 205: -- fa_book_of_controls, gl_sets_of_books, --

201: find_who_columns;
202:
203: ---------------------------------------------------------
204: -- get information regarding the book from --
205: -- fa_book_of_controls, gl_sets_of_books, --
206: -- gl_je_sources, fa_deprn_period and --
207: -- fa_calender_periods --
208: ---------------------------------------------------------
209: x_statement := 'BOOK_INFO';

Line 253: gl_sets_of_books sb,

249: x_user_je_source_name,
250: x_period_name,
251: x_end_date
252: FROM fa_book_controls bc,
253: gl_sets_of_books sb,
254: gl_je_sources js,
255: fa_deprn_periods dp,
256: fa_calendar_periods cp
257: WHERE bc.book_type_code = p_book

Line 293: gl_sets_of_books sb,

289: x_currency_code,
290: x_period_name,
291: x_end_date
292: FROM fa_book_controls bc,
293: gl_sets_of_books sb,
294: fa_deprn_periods dp,
295: fa_calendar_periods cp
296: WHERE bc.book_type_code = p_book
297: AND sb.set_of_books_id = bc.set_of_books_id