4: --
5: -- FUNCTION faxindd
6: --
7:
8: g_release number := fa_cache_pkg.fazarel_release;
9:
10: FUNCTION faxindd (X_book_type_code VARCHAR2,
11: X_asset_id NUMBER,
12: X_period_counter NUMBER := NULL,
415: dh.units_assigned,
416: dp.period_counter
417: FROM fa_distribution_history dh, fa_deprn_periods dp, fa_transaction_headers th
418: WHERE dh.asset_id = X_dpr_dtl.asset_id
419: AND dh.book_type_code = fa_cache_pkg.fazcbc_record.distribution_source_book
420: AND dp.book_type_code = X_dpr_dtl.book
421: AND NVL(dh.date_ineffective, sysdate) >= dp.period_open_date
422: and dh.transaction_header_id_out IS not NULL
423: and th.book_type_code = dh.book_type_code
473:
474: h_msg_name := 'FA_SHARED_DATA_ERR_BC';
475:
476: -- bug# 2140468 - use cache
477: h_dist_book := fa_cache_pkg.fazcbc_record.distribution_source_book;
478:
479: h_msg_name := 'FA_SHARED_DATA_ERR_DH';
480:
481: /*Bug 9142501 - Start:In POA Cost adjustment should not reflect in B row of fa_deprn_detail.