APPS.FA_MASS_RET_PUB dependencies on FA_DEPRN_PERIODS

Line 30: l_fiscal_year fa_deprn_periods.fiscal_year%TYPE;

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

Line 32: l_per_close_date fa_deprn_periods.calendar_period_close_date%TYPE;

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;
36: l_retirement_type_code fa_mass_retirements.retirement_type_code%TYPE;

Line 55: fa_deprn_periods dp

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
59: and bc.book_class <> 'BUDGET'

Line 76: FROM fa_deprn_periods fadp

72: And lookup_code = l_retirement_type_code;
73:
74: cursor c_rd is
75: Select 'Validated'
76: FROM fa_deprn_periods fadp
77: WHERE fadp.book_type_code = l_book
78: AND fadp.period_close_date IS NULL
79: AND l_retirement_date
80: <= fadp.calendar_period_close_date;