APPS.JL_ZZ_FA_DEPRN_ADJ_PKG dependencies on XLA_SUBLEDGERS

Line 60: g_gl_je_source XLA_SUBLEDGERS.JE_SOURCE_NAME%TYPE; -- Bug 5136047

56: g_distribution_source_book FA_BOOK_CONTROLS.DISTRIBUTION_SOURCE_BOOK%TYPE;
57: g_reserve_acct NUMBER(15);
58: g_ccid_deprn_exp_co VARCHAR2(150);
59: g_ccid_deprn_mon_co VARCHAR2(150);
60: g_gl_je_source XLA_SUBLEDGERS.JE_SOURCE_NAME%TYPE; -- Bug 5136047
61: g_conc_segs VARCHAR2(2000);
62: g_period_name FA_DEPRN_PERIODS.PERIOD_NAME%TYPE;
63: g_precision NUMBER;
64: g_period_counter1 FA_DEPRN_PERIODS.PERIOD_COUNTER%TYPE;

Line 174: XLA_SUBLEDGERS for application_id = 140.

170: "GL journal entry source" is set at the application level in SLA.
171: Though, gl_je_source value is available in fa_book_controls
172: for books upgraded from R11i, the source of truth is always as follows.
173: The "GL journal entry source" will be derived from JE_SOURCE_NAME from
174: XLA_SUBLEDGERS for application_id = 140.
175: Hence, there is no need to look at fa_book_controls for books upgraded
176: from R1i.
177:
178: SELECT a.set_of_books_id ,

Line 224: xla_subledgers xs

220: js.user_je_source_name
221: INTO g_gl_je_source,
222: g_user_je_source_name
223: FROM gl_je_sources js,
224: xla_subledgers xs
225: WHERE js.je_source_name = xs.je_source_name
226: AND xs.application_id = 140;
227:
228: -- Get currency precision