DBA Data[Home] [Help]

APPS.FA_REC_PVT_PKG3 dependencies on FA_DEPRN_SUMMARY

Line 436: FROM FA_DEPRN_SUMMARY ds, FA_METHODS mth

432: /* cursor to validate depreciation method change for a
433: short-tax-year asset */
434: CURSOR check_short_tax IS
435: SELECT 'N'
436: FROM FA_DEPRN_SUMMARY ds, FA_METHODS mth
437: WHERE mth.method_code = p_old_deprn_method
438: AND mth.rate_source_rule = 'FORMULA'
439: AND ds.asset_id = p_asset_id
440: AND ds.book_type_code = p_book_type_code

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

468: OPEN get_book_class;
469: FETCH get_book_class INTO l_book_class;
470: CLOSE get_book_class;
471:
472: SELECT count(1) INTO l_count FROM FA_DEPRN_SUMMARY
473: WHERE book_type_code = p_book_type_code AND asset_id = p_asset_id
474: AND deprn_source_code = 'DEPRN' AND deprn_amount <> 0
475: AND rownum < 2;
476: