[Home] [Help]
70: x_book_class fa_book_controls.book_class%TYPE;
71: x_gl_posting_allowed_flag fa_book_controls.gl_posting_allowed_flag%TYPE;
72: x_current_fiscal_year fa_book_controls.current_fiscal_year%TYPE;
73: x_accounting_flex_structure fa_book_controls.accounting_flex_structure%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;
214: "GL journal entry source" is set at the application level in SLA.
215: Though, gl_je_source value is available in fa_book_controls
216: for books upgraded from R11i, the source of truth is always as follows.
217: The "GL journal entry source" will be derived from JE_SOURCE_NAME from
218: XLA_SUBLEDGERS for application_id = 140.
219: Hence, there is no need to look at fa_book_controls for books upgraded
220: from R1i.
221:
222: SELECT bc.set_of_books_id,
304: js.user_je_source_name
305: INTO x_gl_je_source,
306: x_user_je_source_name
307: FROM gl_je_sources js,
308: xla_subledgers xs
309: WHERE js.je_source_name = xs.je_source_name
310: AND xs.application_id = 140;
311:
312: