DBA Data[Home] [Help]

APPS.FA_WHATIF_DEPRN2_PKG dependencies on FA_METHODS

Line 156: fa_methods fam

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
160: and period_counter_fully_reserved is null

Line 595: from fa_methods m, fa_flat_rates r

591: if (X_adjusted_rate is not null) then
592:
593: select r.basic_rate
594: into h_basic_rate
595: from fa_methods m, fa_flat_rates r
596: where m.method_code = X_method
597: and m.method_id = r.method_id
598: and r.adjusted_rate = X_adjusted_rate and rownum < 2;
599:

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)