DBA Data[Home] [Help]

APPS.FA_MASS_RECLASS_PKG dependencies on FA_BOOK_CONTROLS

Line 81: fa_book_controls bc,

77: ad.asset_category_id,
78: dh.assigned_to
79: FROM gl_code_combinations gc,
80: fa_distribution_history dh,
81: fa_book_controls bc,
82: fa_books bk,
83: fa_additions_b ad
84: WHERE ad.asset_type = nvl(mr_rec.asset_type, ad.asset_type)
85: AND ad.asset_number >= nvl(mr_rec.from_asset_number, ad.asset_number)

Line 622: FROM fa_book_controls bc, fa_books bk

618:
619: -- cursor to get all the corporate and tax books the asset belongs to.
620: CURSOR book_cr IS
621: SELECT bk.book_type_code
622: FROM fa_book_controls bc, fa_books bk
623: WHERE bk.asset_id = X_Asset_Id
624: AND bk.date_ineffective IS NULL
625: AND bk.book_type_code = bc.book_type_code
626: AND bc.book_class IN ('CORPORATE', 'TAX')