APPS.JL_CO_FA_TA_REVAL_PKG dependencies on FA_CALENDAR_PERIODS

Line 83: x_end_date fa_calendar_periods.end_date%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;
85: x_prev_revaluation jl_co_fa_asset_apprs.appraisal_value%TYPE := 0;
86: x_net_revaluation jl_co_fa_asset_apprs.appraisal_value%TYPE := 0;
87: x_category_id fa_additions.asset_category_id%TYPE := 0;

Line 256: fa_calendar_periods cp

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
259: AND js.je_source_name = bc.gl_je_source
260: AND dp.book_type_code = p_book

Line 295: fa_calendar_periods cp

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
298: AND dp.book_type_code = p_book
299: AND dp.period_counter = bc.last_period_counter