DBA Data[Home] [Help]

APPS.FA_WHATIF_DEPRN2_PKG dependencies on FA_BOOKS

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)

Line 711: -- from fa_books bk, fa_deprn_periods dp, fa_deprn_periods bdp

707: -- SCREEN OUT ASSETS ADDED IN CURRENT PERIOD;
708: -- THESE WOULD JUST GET ADDITION,ADDITION/VOID TRX'S ANYWAYS.
709:
710: -- select count(*) into h_check_cur_add
711: -- from fa_books bk, fa_deprn_periods dp, fa_deprn_periods bdp
712: -- where bdp.period_counter = dp.period_counter
713: -- and dp.period_close_date is not null
714: -- and bk.date_placed_in_service between
715: -- bdp.period_open_date and nvl(bdp.period_close_date, sysdate)