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 612: FROM fa_book_controls bc, fa_books bk

608:
609: -- cursor to get all the corporate and tax books the asset belongs to.
610: CURSOR book_cr IS
611: SELECT bk.book_type_code
612: FROM fa_book_controls bc, fa_books bk
613: WHERE bk.asset_id = X_Asset_Id
614: AND bk.date_ineffective IS NULL
615: AND bk.book_type_code = bc.book_type_code
616: AND bc.book_class IN ('CORPORATE', 'TAX')