DBA Data[Home] [Help]

APPS.FA_WHATIF_DEPRN2_PKG dependencies on FA_ADDITIONS

Line 597: from fa_books bk, fa_additions ad

593: h_mesg_str varchar2(2000);
594:
595: cursor assets is
596: select bk.asset_id, bk.deprn_method_code, ad.asset_number
597: from fa_books bk, fa_additions ad
598: where ad.asset_category_id = nvl(X_category_id,ad.asset_category_id)
599: and ad.description like nvl(X_description,ad.description)
600: and ad.asset_number >= nvl(X_begin_asset,ad.asset_number)
601: and ad.asset_number <= nvl(X_end_asset,ad.asset_number)