APPS.FA_WHATIF_DEPRN2_PKG dependencies on FA_BOOKS

Line 155: from fa_books fb,

151: cursor c_aset(x_book_type varchar2, x_asset_id NUMBER) is
152: select to_char(fb.date_placed_in_service) dtin_srv,fb.book_type_code,
153: fb.asset_id,fb.deprn_method_code,fb.adjusted_cost,fb.cost,fb.life_in_months,fb.rate_in_use,
154: fb.allowed_deprn_limit_amount
155: from fa_books fb,
156: fa_methods fam
157: where fb.deprn_method_code = fam.method_code
158: and NVL(fam.guarantee_rate_method_flag,'NO') = 'YES'
159: and fb.date_ineffective is null

Line 168: from fa_books fb

164: --ERnos 6612615 what-if extnd deprn start
165: cursor c_extnd_asset(x_book_type varchar2, x_asset_id NUMBER) is
166: select fb.book_type_code,
167: fb.asset_id
168: from fa_books fb
169: where fb.date_ineffective is null
170: and fb.book_type_code = x_book_type
171: and fb.asset_id = x_asset_id
172: AND FB.deprn_method_code <> 'JP-STL-EXTND'

Line 709: from fa_books bk, fa_additions ad, fa_methods mt

705: h_mesg_str varchar2(2000);
706:
707: cursor assets is
708: select bk.asset_id, bk.deprn_method_code, ad.asset_number
709: from fa_books bk, fa_additions ad, fa_methods mt
710: where ad.asset_category_id = nvl(X_category_id,ad.asset_category_id)
711: and ad.description like nvl(X_description,ad.description)
712: and ad.asset_number >= nvl(X_begin_asset,ad.asset_number)
713: and ad.asset_number <= nvl(X_end_asset,ad.asset_number)

Line 827: -- from fa_books bk, fa_deprn_periods dp, fa_deprn_periods bdp

823: -- SCREEN OUT ASSETS ADDED IN CURRENT PERIOD;
824: -- THESE WOULD JUST GET ADDITION,ADDITION/VOID TRX'S ANYWAYS.
825:
826: -- select count(*) into h_check_cur_add
827: -- from fa_books bk, fa_deprn_periods dp, fa_deprn_periods bdp
828: -- where bdp.period_counter = dp.period_counter
829: -- and dp.period_close_date is not null
830: -- and bk.date_placed_in_service between
831: -- bdp.period_open_date and nvl(bdp.period_close_date, sysdate)