APPS.FARX_RP dependencies on FA_BOOKS

Line 106: fa_books bk,

102: ad.asset_category_id
103: FROM gl_code_combinations gc,
104: fa_distribution_history dh,
105: fa_book_controls bc,
106: fa_books bk,
107: fa_additions ad
108: WHERE ad.asset_type = nvl(mr_rec.asset_type, ad.asset_type)
109: AND ad.asset_number >= nvl(mr_rec.from_asset_number, ad.asset_number)
110: AND ad.asset_number <= nvl(mr_rec.to_asset_number, ad.asset_number)

Line 652: FROM fa_book_controls bc, fa_books bk

648: -- cursor to get all the corporate and tax books the asset belongs to.
649: -- books are ordered in alphabetical order in preview report.
650: CURSOR book_cr IS
651: SELECT bk.book_type_code
652: FROM fa_book_controls bc, fa_books bk
653: WHERE bk.asset_id = a_tbl(a_index).asset_id
654: AND bk.date_ineffective IS NULL
655: AND bk.book_type_code = bc.book_type_code
656: AND bc.book_class IN ('CORPORATE', 'TAX')

Line 679: FROM FA_BOOKS

675:
676: -- cursor to get date placed in service and depreciate flag.
677: CURSOR get_dpis_deprn_flag IS
678: SELECT date_placed_in_service, depreciate_flag
679: FROM FA_BOOKS
680: WHERE asset_id = a_tbl(a_index).asset_id
681: AND book_type_code = h_book_type_code
682: AND date_ineffective IS NULL;
683:

Line 691: FROM FA_BOOKS

687: life_in_months, basic_rate, adjusted_rate,
688: bonus_rule, production_capacity, unit_of_measure,
689: depreciate_flag, allowed_deprn_limit, allowed_deprn_limit_amount,
690: percent_salvage_value
691: FROM FA_BOOKS
692: WHERE asset_id = a_tbl(a_index).asset_id
693: AND book_type_code = h_book_type_code
694: AND date_ineffective IS NULL;
695:

Line 1017: FROM FA_BOOKS bk

1013: AND dp.period_close_date is null;
1014: -- Cursor to get date placed in service.
1015: CURSOR get_dpis IS
1016: SELECT date_placed_in_service
1017: FROM FA_BOOKS bk
1018: WHERE bk.asset_id = X_Asset_Id
1019: AND bk.book_type_code = X_Book_Type_Code
1020: AND date_ineffective IS NULL;
1021: BEGIN