APPS.FA_INS_DETAIL_PKG dependencies on FA_DEPRN_PERIODS

Line 417: FROM fa_distribution_history dh, fa_deprn_periods dp, fa_transaction_headers th

413: CURSOR C2 IS
414: SELECT dh.distribution_id,
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

Line 432: from fa_deprn_periods dp2

428: /*Bug#7836587 - Added REINSTATEMENT */
429: and dh.transaction_header_id_out = th.transaction_header_id
430: and dp.fiscal_year =
431: (select fiscal_year
432: from fa_deprn_periods dp2
433: where dp2.period_close_date is NULL
434: and book_type_code = X_dpr_dtl.book)
435: ORDER BY dh.distribution_id;
436: