DBA Data[Home] [Help]

APPS.FA_MASS_RET_PKG dependencies on FA_DEPRN_PERIODS

Line 884: fa_deprn_periods dp

880: CURSOR check_current_period_add is
881: select 'FA_RET_CANT_RET_NONDEPRN'
882: from fa_transaction_headers th,
883: fa_book_controls bc,
884: fa_deprn_periods dp
885: where th.asset_id = p_Asset_id
886: AND th.book_type_code = G_Book_Type_Code
887: AND bc.book_type_code = th.book_type_code
888: AND th.transaction_type_code||''

Line 998: fa_deprn_periods dp

994:
995: CURSOR check_asset_life_complete IS
996: select 'EXTENDED LIFE'
997: from fa_books bk,
998: fa_deprn_periods dp
999: where bk.asset_id = X_Asset_Id
1000: AND bk.book_type_code = G_Book_Type_Code
1001: AND nvl(period_Counter_fully_reserved,99) <> bk.period_counter_life_complete
1002: AND dp.book_type_code = bk.book_type_code