APPS.FA_REC_PVT_PKG3 dependencies on FA_DEPRN_SUMMARY

Line 453: FROM FA_DEPRN_SUMMARY ds, FA_METHODS mth

449: /* cursor to validate depreciation method change for a
450: short-tax-year asset */
451: CURSOR check_short_tax IS
452: SELECT 'N'
453: FROM FA_DEPRN_SUMMARY ds, FA_METHODS mth
454: WHERE mth.method_code = p_old_deprn_method
455: AND mth.rate_source_rule = 'FORMULA'
456: AND ds.asset_id = p_asset_id
457: AND ds.book_type_code = p_book_type_code

Line 489: SELECT count(1) INTO l_count FROM FA_DEPRN_SUMMARY

485: OPEN get_book_class;
486: FETCH get_book_class INTO l_book_class;
487: CLOSE get_book_class;
488:
489: SELECT count(1) INTO l_count FROM FA_DEPRN_SUMMARY
490: WHERE book_type_code = p_book_type_code AND asset_id = p_asset_id
491: AND deprn_source_code = 'DEPRN' AND deprn_amount <> 0
492: AND rownum < 2;
493: