DBA Data[Home] [Help]

APPS.FA_MASSCHG_PKG dependencies on FA_BOOKS

Line 181: fa_books bk,

177: cursor c_assets_uom is
178: select ad.asset_number,
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

Line 231: fa_books bk,

227: bk.date_effective,
228: bk.date_placed_in_service,
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,

Line 320: fa_books bk,

316: bk.date_effective,
317: bk.date_placed_in_service,
318: bk.group_asset_id
319: from fa_additions_b ad,
320: fa_books bk,
321: fa_mass_changes mch
322: where ad.asset_number >=
323: nvl(mch.from_asset_number,
324: ad.asset_number)

Line 596: update fa_books bk

592: p_log_level_rec => g_log_level_rec);
593:
594: BEGIN
595:
596: update fa_books bk
597: set bk.unit_of_measure = l_to_uom,
598: bk.last_update_date = sysdate,
599: bk.last_updated_by = l_userid,
600: bk.last_update_login = l_login,

Line 704: fa_books bk,

700:
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

Line 733: fa_books bk,

729:
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

Line 902: from fa_books

898: l_old_salvage_value,
899: l_old_deprn_limit_type,
900: l_old_deprn_limit,
901: l_old_deprn_limit_amount
902: from fa_books
903: where book_type_code = l_book_type_code
904: and asset_id = l_asset_id(l_loop_count)
905: and transaction_header_id_out is null;
906:

Line 984: update fa_books bk

980: -- Update UOM in TAX books if PROD method
981: if (nvl(l_from_uom, 'NULL') <> nvl(l_to_uom, 'NULL')) then
982:
983: -- 'FA_MASSCHG_UPDATE_TAX_UOM'
984: update fa_books bk
985: set bk.unit_of_measure = l_to_uom,
986: bk.last_update_date = sysdate,
987: bk.last_updated_by = l_userid,
988: bk.last_update_login = l_login,