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 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')

Line 621: FROM fa_books bk

617: AND nvl(bc.date_ineffective, sysdate+1) > sysdate;
618:
619: CURSOR check_not_rsvd IS
620: SELECT 'NOT RESERVED'
621: FROM fa_books bk
622: WHERE bk.asset_id = X_Asset_Id
623: AND bk.book_type_code = l_book
624: AND bk.date_ineffective IS NULL
625: AND bk.period_counter_fully_reserved IS NULL;

Line 629: FROM fa_books bk

625: AND bk.period_counter_fully_reserved IS NULL;
626:
627: CURSOR check_rsvd IS
628: SELECT 'RESERVED'
629: FROM fa_books bk
630: WHERE bk.asset_id = X_Asset_Id
631: AND bk.book_type_code = l_book
632: AND bk.date_ineffective IS NULL
633: AND bk.period_counter_fully_reserved IS NOT NULL;