APPS.FA_WHATIF_DEPRN2_PKG dependencies on FA_DEPRN_DETAIL

Line 802: from fa_deprn_detail

798:
799: h_mesg_name := 'FA_WHATIF_ASSET_CHK_DEPRN';
800:
801: select count(*) into h_check
802: from fa_deprn_detail
803: where asset_id = h_asset_id
804: and book_type_code = X_book
805: and deprn_source_code = 'B'
806: and not exists (select 1

Line 807: from fa_deprn_detail dd1

803: where asset_id = h_asset_id
804: and book_type_code = X_book
805: and deprn_source_code = 'B'
806: and not exists (select 1
807: from fa_deprn_detail dd1
808: where asset_id = h_asset_id
809: and book_type_code = X_book
810: and deprn_source_code = 'D'
811: and deprn_amount <> 0 ); -- bugfix 2223451 commented deprn_amount > 0;