APPS.FA_INS_DETAIL_PKG dependencies on FA_DISTRIBUTION_HISTORY

Line 393: FROM fa_distribution_history

389: h_cost_to_clear NUMBER := 0; --Bug 9142501
390:
391: CURSOR C1_11 IS
392: SELECT distribution_id, units_assigned
393: FROM fa_distribution_history
394: WHERE book_type_code = h_dist_book AND
395: asset_id = h_asset_id AND
396: date_ineffective IS NULL
397: ORDER BY distribution_id;

Line 403: FROM fa_distribution_history

399: --Changed for 9128700
400:
401: CURSOR C1 IS
402: SELECT distribution_id, units_assigned
403: FROM fa_distribution_history
404: WHERE book_type_code = h_dist_book
405: AND asset_id = h_asset_id
406: AND h_add_date BETWEEN
407: date_effective AND NVL(date_ineffective,SYSDATE)

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 503: FROM fa_distribution_history dh

499:
500: if (G_release = 11 or X_source_flag = FALSE) then
501: SELECT nvl(SUM(dh.units_assigned),0), COUNT(*)
502: INTO h_total_units, h_dist_count
503: FROM fa_distribution_history dh
504: WHERE dh.book_type_code = h_dist_book AND
505: dh.asset_id = h_asset_id AND
506: dh.date_ineffective IS NULL;
507: else

Line 513: -- have a situation where we are using Tax Book and fa_distribution_history does

509: -- Period of addition we always have to take Distributions at the time of
510: -- additions into consideration . Commented dh.date_ineffective is null
511: -- condition
512: -- Bug 8281792 ... We need to pass h_dist_book for book_type_code, since we can
513: -- have a situation where we are using Tax Book and fa_distribution_history does
514: -- not contain units. Also rewritten the query using EXISTS cluase
515:
516: --Modified for 9128700
517:

Line 539: FROM fa_distribution_history dh

535:
536:
537: SELECT nvl(SUM(dh.units_assigned),0), COUNT(*)
538: INTO h_total_units, h_dist_count
539: FROM fa_distribution_history dh
540: WHERE dh.book_type_code = h_dist_book
541: AND dh.asset_id = h_asset_id
542: AND h_add_date BETWEEN
543: date_effective AND NVL(date_ineffective,SYSDATE);