APPS.JL_CO_FA_TA_REVAL_PKG dependencies on GL_JE_SOURCES

Line 80: x_user_je_source_name gl_je_sources.user_je_source_name%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;
83: x_end_date fa_calendar_periods.end_date%TYPE;
84: x_appr_revaluation jl_co_fa_asset_apprs.appraisal_value%TYPE := 0;

Line 206: -- gl_je_sources, fa_deprn_period and --

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';
210:

Line 254: gl_je_sources js,

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
258: AND sb.set_of_books_id = bc.set_of_books_id

Line 307: FROM gl_je_sources js,

303: SELECT xs.je_source_name,
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: