APPS.FA_WHATIF_DEPRN2_PKG dependencies on FA_DEPRN_DETAIL

Line 686: from fa_deprn_detail

682:
683: h_mesg_name := 'FA_WHATIF_ASSET_CHK_DEPRN';
684:
685: select count(*) into h_check
686: from fa_deprn_detail
687: where asset_id = h_asset_id
688: and book_type_code = X_book
689: and deprn_source_code = 'B'
690: and not exists (select 1

Line 691: from fa_deprn_detail dd1

687: where asset_id = h_asset_id
688: and book_type_code = X_book
689: and deprn_source_code = 'B'
690: and not exists (select 1
691: from fa_deprn_detail dd1
692: where asset_id = h_asset_id
693: and book_type_code = X_book
694: and deprn_source_code = 'D'
695: and deprn_amount <> 0 ); -- bugfix 2223451 commented deprn_amount > 0;