APPS.FARX_RP dependencies on FA_BOOKS

Line 108: fa_books bk,

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

Line 675: FROM fa_book_controls bc, fa_books bk

671: -- cursor to get all the corporate and tax books the asset belongs to.
672: -- books are ordered in alphabetical order in preview report.
673: CURSOR book_cr IS
674: SELECT bk.book_type_code
675: FROM fa_book_controls bc, fa_books bk
676: WHERE bk.asset_id = a_tbl(a_index).asset_id
677: AND bk.date_ineffective IS NULL
678: AND bk.book_type_code = bc.book_type_code
679: AND bc.book_class IN ('CORPORATE', 'TAX')

Line 702: FROM FA_BOOKS

698:
699: -- cursor to get date placed in service and depreciate flag.
700: CURSOR get_dpis_deprn_flag IS
701: SELECT date_placed_in_service, depreciate_flag
702: FROM FA_BOOKS
703: WHERE asset_id = a_tbl(a_index).asset_id
704: AND book_type_code = h_book_type_code
705: AND date_ineffective IS NULL;
706:

Line 714: FROM FA_BOOKS

710: life_in_months, basic_rate, adjusted_rate,
711: bonus_rule, production_capacity, unit_of_measure,
712: depreciate_flag, allowed_deprn_limit, allowed_deprn_limit_amount,
713: percent_salvage_value
714: FROM FA_BOOKS
715: WHERE asset_id = a_tbl(a_index).asset_id
716: AND book_type_code = h_book_type_code
717: AND date_ineffective IS NULL;
718:

Line 1047: FROM FA_BOOKS bk

1043: AND dp.period_close_date is null;
1044: -- Cursor to get date placed in service.
1045: CURSOR get_dpis IS
1046: SELECT date_placed_in_service
1047: FROM FA_BOOKS bk
1048: WHERE bk.asset_id = X_Asset_Id
1049: AND bk.book_type_code = X_Book_Type_Code
1050: AND date_ineffective IS NULL;
1051: BEGIN