DBA Data[Home] [Help]

APPS.FA_MASSCHG_PKG dependencies on FA_METHODS

Line 186: fa_methods me

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

Line 522: fa_methods me

518: bk.date_ineffective is null and
519: bk.book_type_code in
520: (select bc.book_type_code
521: from fa_book_controls bc,
522: fa_methods me
523: where bc.date_ineffective is null
524: and bc.distribution_source_book = l_book_type_code
525: and bc.book_class <> 'BUDGET'
526: and me.method_code = bk.deprn_method_code

Line 623: fa_methods me

619: select count(*)
620: into l_count
621: from fa_book_controls bc,
622: fa_books bk,
623: fa_methods me
624: where bk.book_type_code = bc.book_type_code
625: and bk.asset_id = l_asset_id(l_loop_count)
626: and bk.date_ineffective is null
627: and bc.distribution_source_book = l_book_type_code

Line 652: fa_methods me

648: select count(*)
649: into l_count
650: from fa_book_controls bc,
651: fa_books bk,
652: fa_methods me
653: where bk.book_type_code = bc.distribution_source_book
654: and bk.asset_id = l_asset_id(l_loop_count)
655: and bk.date_ineffective is null
656: and bc.book_type_code = l_book_type_code

Line 913: fa_methods me

909: and bk.date_ineffective is null
910: and bk.book_type_code in
911: (select bc.book_type_code
912: from fa_book_controls bc,
913: fa_methods me
914: where bc.distribution_source_book = l_book_type_code
915: and bc.book_class = 'TAX'
916: and bc.date_ineffective is null
917: and me.method_code = bk.deprn_method_code