DBA Data[Home] [Help]

APPS.FA_TRANSFER_PUB dependencies on FA_DEPRN_PERIODS

Line 361: FA_DEPRN_PERIODS dp

357:
358: SELECT count(1)
359: INTO l_count
360: FROM FA_TRANSACTION_HEADERS th,
361: FA_DEPRN_PERIODS dp
362: WHERE th.asset_id = nvl(p_asset_hdr_rec.asset_id, -1)
363: AND th.book_type_code = nvl(p_asset_hdr_rec.book_type_code,'XX')
364: AND th.transaction_type_code||'' = 'TRANSFER'
365: AND th.transaction_date_entered < dp.calendar_period_open_date

Line 384: FROM FA_BOOKS bk, FA_DEPRN_PERIODS dp

380: -- prior period tfr is not allowed after assets' normal life complete
381:
382: SELECT count(1)
383: INTO l_count
384: FROM FA_BOOKS bk, FA_DEPRN_PERIODS dp
385: WHERE bk.asset_id = p_asset_hdr_rec.asset_id
386: AND bk.book_type_code = p_asset_hdr_rec.book_type_code
387: AND nvl(period_counter_fully_reserved, 99) <>
388: nvl(period_counter_life_complete, 99)