APPS.FA_MASS_ADD_VALIDATE dependencies on FA_DEPRN_PERIODS

Line 217: from fa_deprn_periods dp, fa_book_controls bc

213: return number
214: is
215: cursor c1 (x_date_in_service IN date) is
216: select count(*) dummy
217: from fa_deprn_periods dp, fa_book_controls bc
218: where trunc(x_date_in_service) >
219: trunc(nvl(dp.calendar_period_close_date,
220: x_date_in_service))
221: and bc.book_class = 'CORPORATE'

Line 232: from fa_deprn_periods dp

228: cursor c2 is
229: select greatest(dp.calendar_period_open_date,
230: least(sysdate, dp.calendar_period_close_date))
231: valid_date
232: from fa_deprn_periods dp
233: where dp.book_type_code = nvl(x_book_type_code, 'X')
234: and dp.period_close_date is null;
235: c2_rec c2%rowtype;
236: */