APPS.FA_FIN_ADD_PKG dependencies on FA_DEPRN_PERIODS

Line 158: from fa_deprn_periods dp

154: -- default date placed in service
155: select greatest(dp.calendar_period_open_date,
156: least(sysdate,dp.calendar_period_close_date))
157: into X_DPIS
158: from fa_deprn_periods dp
159: where dp.book_type_code = X_BOOK_TYPE_CODE
160: and dp.period_close_date is null;
161: --
162: -- get acct flex info

Line 208: from fa_deprn_periods

204: BEGIN
205: -- dpis must not be in a future period
206: select count(*)
207: into lv_count
208: from fa_deprn_periods
209: where book_type_code = X_BOOK_TYPE_CODE
210: and period_close_date is null
211: and X_DPIS > calendar_period_close_date;
212: --