APPS.JL_CO_FA_TA_REVAL_PKG dependencies on FA_DEPRN_PERIODS

Line 79: x_period_name fa_deprn_periods.period_name%TYPE;

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;
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;

Line 255: fa_deprn_periods dp,

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

Line 294: fa_deprn_periods dp,

290: x_period_name,
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

Line 1577: FROM fa_deprn_periods

1573:
1574: x_statement := 'PERIOD_INFO';
1575: SELECT period_counter
1576: INTO x_period_counter
1577: FROM fa_deprn_periods
1578: WHERE book_type_code = p_book_type_code
1579: AND period_close_date IS NULL;
1580:
1581: