APPS.FA_INS_DETAIL_PKG dependencies on FA_TRANSACTION_HEADERS

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 440: FA_TRANSACTION_HEADERS th

436:
437: CURSOR C_MC_COST_TO_CLEAR IS --Bug 9142501
438: SELECT NVL(SUM(DECODE(adj.debit_credit_flag,'DR', -1 * adj.adjustment_amount, adj.adjustment_amount)),0)
439: FROM FA_MC_ADJUSTMENTS adj,
440: FA_TRANSACTION_HEADERS th
441: WHERE adj.book_type_code(+) = h_book_type_code
442: AND adj.asset_id(+) = h_asset_id
443: AND adj.adjustment_type(+) = decode (th.transaction_type_code, 'CIP ADDITION', 'CIP COST', 'ADDITION', 'COST')
444: AND adj.distribution_id(+) = h_dist_id

Line 454: FA_TRANSACTION_HEADERS th

450:
451: CURSOR C_COST_TO_CLEAR IS --Bug 9142501
452: SELECT NVL(SUM(DECODE(adj.debit_credit_flag,'DR', -1 * adj.adjustment_amount, adj.adjustment_amount)),0)
453: FROM FA_ADJUSTMENTS adj,
454: FA_TRANSACTION_HEADERS th
455: WHERE adj.book_type_code(+) = h_book_type_code
456: AND adj.asset_id(+) = h_asset_id
457: AND adj.adjustment_type(+) = decode (th.transaction_type_code, 'CIP ADDITION', 'CIP COST', 'ADDITION', 'COST')
458: AND adj.distribution_id(+) = h_dist_id

Line 522: FROM fa_transaction_headers

518: BEGIN
519:
520: SELECT MIN(date_effective)
521: INTO h_add_date
522: FROM fa_transaction_headers
523: WHERE book_type_code = h_book_type_code
524: AND asset_id = h_asset_id
525: AND transaction_type_code LIKE '%ADDITION%';
526: