APPS.FA_MASS_ADD_VALIDATE dependencies on FA_DEPRN_PERIODS

Line 214: from fa_deprn_periods dp, fa_book_controls bc

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

Line 229: from fa_deprn_periods dp

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