APPS.JL_CO_FA_POST_PKG dependencies on XLA_SUBLEDGERS

Line 51: x_gl_je_source xla_subledgers.je_source_name%TYPE; -- Bug 5136047

47: p_book VARCHAR2) IS
48:
49: x_set_of_book_id fa_book_controls.set_of_books_id%TYPE;
50: x_deprn_calendar fa_book_controls.deprn_calendar%TYPE;
51: x_gl_je_source xla_subledgers.je_source_name%TYPE; -- Bug 5136047
52: x_distribution_source_book fa_book_controls.distribution_source_book%TYPE;
53: x_period_counter VARCHAR2(150);
54: x_period_closed VARCHAR2(150);
55: x_user_je_source_name gl_je_sources.user_je_source_name%TYPE;

Line 151: XLA_SUBLEDGERS for application_id = 140.

147: "GL journal entry source" is set at the application level in SLA.
148: Though, gl_je_source value is available in fa_book_controls
149: for books upgraded from R11i, the source of truth is always as follows.
150: The "GL journal entry source" will be derived from JE_SOURCE_NAME from
151: XLA_SUBLEDGERS for application_id = 140.
152: Hence, there is no need to look at fa_book_controls for books upgraded
153: from R1i.
154:
155: SELECT bc.set_of_books_id,

Line 193: xla_subledgers xs

189: js.user_je_source_name
190: INTO x_gl_je_source,
191: x_user_je_source_name
192: FROM gl_je_sources js,
193: xla_subledgers xs
194: WHERE js.je_source_name = xs.je_source_name
195: AND xs.application_id = 140;
196:
197: