APPS.FA_MASS_RET_PUB dependencies on FA_BOOK_CONTROLS

Line 29: l_fiscal_year_name fa_book_controls.fiscal_year_name%TYPE;

25: -- validation cursors
26:
27: l_found varchar2(30);
28:
29: l_fiscal_year_name fa_book_controls.fiscal_year_name%TYPE;
30: l_fiscal_year fa_deprn_periods.fiscal_year%TYPE;
31: l_book_class fa_book_controls.book_class%TYPE;
32: l_per_close_date fa_deprn_periods.calendar_period_close_date%TYPE;
33: l_book fa_book_controls.book_type_code%TYPE;

Line 31: l_book_class fa_book_controls.book_class%TYPE;

27: l_found varchar2(30);
28:
29: l_fiscal_year_name fa_book_controls.fiscal_year_name%TYPE;
30: l_fiscal_year fa_deprn_periods.fiscal_year%TYPE;
31: l_book_class fa_book_controls.book_class%TYPE;
32: l_per_close_date fa_deprn_periods.calendar_period_close_date%TYPE;
33: l_book fa_book_controls.book_type_code%TYPE;
34:
35: l_category_id fa_categories.category_id%TYPE;

Line 33: l_book fa_book_controls.book_type_code%TYPE;

29: l_fiscal_year_name fa_book_controls.fiscal_year_name%TYPE;
30: l_fiscal_year fa_deprn_periods.fiscal_year%TYPE;
31: l_book_class fa_book_controls.book_class%TYPE;
32: l_per_close_date fa_deprn_periods.calendar_period_close_date%TYPE;
33: l_book fa_book_controls.book_type_code%TYPE;
34:
35: l_category_id fa_categories.category_id%TYPE;
36: l_retirement_type_code fa_mass_retirements.retirement_type_code%TYPE;
37: l_retirement_date date;

Line 54: from fa_book_controls bc,

50: select bc.fiscal_year_name,
51: bc.current_fiscal_year,
52: bc.book_class,
53: dp.calendar_period_close_date
54: from fa_book_controls bc,
55: fa_deprn_periods dp
56: where bc.book_type_code = l_book
57: and bc.last_period_counter = dp.period_counter
58: and dp.book_type_code = bc.book_type_code