DBA Data[Home] [Help]

APPS.FA_FIN_ADD_PKG dependencies on FA_DEPRN_PERIODS

Line 153: from fa_deprn_periods dp

149: -- default date placed in service
150: select greatest(dp.calendar_period_open_date,
151: least(sysdate,dp.calendar_period_close_date))
152: into X_DPIS
153: from fa_deprn_periods dp
154: where dp.book_type_code = X_BOOK_TYPE_CODE
155: and dp.period_close_date is null;
156: --
157: -- get acct flex info

Line 200: from fa_deprn_periods

196: BEGIN
197: -- dpis must not be in a future period
198: select count(*)
199: into lv_count
200: from fa_deprn_periods
201: where book_type_code = X_BOOK_TYPE_CODE
202: and period_close_date is null
203: and X_DPIS > calendar_period_close_date;
204: --