APPS.FA_MASSCHG_PKG dependencies on FA_METHODS

Line 183: fa_methods me

179: bk.asset_id
180: from fa_additions_b ad,
181: fa_books bk,
182: fa_mass_changes mch,
183: fa_methods me
184: where mch.mass_change_id = p_mass_change_id
185: and bk.transaction_header_id_out is null
186: and bk.book_type_code = mch.book_type_code
187: and bk.date_placed_in_service >=

Line 233: fa_methods mt --Bug 8928436

229: bk.group_asset_id
230: from fa_additions_b ad,
231: fa_books bk,
232: fa_mass_changes mch,
233: fa_methods mt --Bug 8928436
234: where ad.asset_number >=
235: nvl(mch.from_asset_number,
236: ad.asset_number)
237: and ad.asset_number <=

Line 607: fa_methods me

603: bk.date_ineffective is null and
604: bk.book_type_code in
605: (select bc.book_type_code
606: from fa_book_controls bc,
607: fa_methods me
608: where bc.date_ineffective is null
609: and bc.distribution_source_book = l_book_type_code
610: and bc.book_class <> 'BUDGET'
611: and me.method_code = bk.deprn_method_code

Line 705: fa_methods me

701: select count(*)
702: into l_count
703: from fa_book_controls bc,
704: fa_books bk,
705: fa_methods me
706: where bk.book_type_code = bc.book_type_code
707: and bk.asset_id = l_asset_id(l_loop_count)
708: and bk.date_ineffective is null
709: and bc.distribution_source_book = l_book_type_code

Line 734: fa_methods me

730: select count(*)
731: into l_count
732: from fa_book_controls bc,
733: fa_books bk,
734: fa_methods me
735: where bk.book_type_code = bc.distribution_source_book
736: and bk.asset_id = l_asset_id(l_loop_count)
737: and bk.date_ineffective is null
738: and bc.book_type_code = l_book_type_code

Line 995: fa_methods me

991: and bk.date_ineffective is null
992: and bk.book_type_code in
993: (select bc.book_type_code
994: from fa_book_controls bc,
995: fa_methods me
996: where bc.distribution_source_book = l_book_type_code
997: and bc.book_class = 'TAX'
998: and bc.date_ineffective is null
999: and me.method_code = bk.deprn_method_code