APPS.FA_MASS_RECLASS_PKG dependencies on FA_BOOKS

Line 82: fa_books bk,

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)
86: AND ad.asset_number <= nvl(mr_rec.to_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')

Line 631: FROM fa_books bk

627: AND nvl(bc.date_ineffective, sysdate+1) > sysdate;
628:
629: CURSOR check_not_rsvd IS
630: SELECT 'NOT RESERVED'
631: FROM fa_books bk
632: WHERE bk.asset_id = X_Asset_Id
633: AND bk.book_type_code = l_book
634: AND bk.date_ineffective IS NULL
635: AND bk.period_counter_fully_reserved IS NULL;

Line 639: FROM fa_books bk

635: AND bk.period_counter_fully_reserved IS NULL;
636:
637: CURSOR check_rsvd IS
638: SELECT 'RESERVED'
639: FROM fa_books bk
640: WHERE bk.asset_id = X_Asset_Id
641: AND bk.book_type_code = l_book
642: AND bk.date_ineffective IS NULL
643: AND bk.period_counter_fully_reserved IS NOT NULL;