APPS.FA_IMPAIRMENT_PREV_PVT dependencies on FA_DEPRN_SUMMARY

Line 1950: exists (select 1 from fa_deprn_summary ds

1946: (
1947: th.transaction_type_code = 'ADDITION'
1948: and (
1949: (
1950: exists (select 1 from fa_deprn_summary ds
1951: where ds.deprn_reserve <> 0
1952: and ds.book_type_code = p_book_type_code
1953: and ds.asset_id = p_asset_id
1954: and ds.deprn_source_code = 'BOOKS')

Line 1973: and exists (select 1 from fa_deprn_summary ds

1969: th.transaction_date_entered), p_date_placed_in_service)
1970: --to_date('01-JAN-1996', 'DD-MON-YYYY')
1971: between cp.start_date
1972: and cp.end_date
1973: and exists (select 1 from fa_deprn_summary ds
1974: where ds.deprn_reserve = 0
1975: and ds.book_type_code = p_book_type_code
1976: and ds.asset_id = p_asset_id
1977: and ds.deprn_source_code = 'BOOKS')

Line 2095: FROM fa_deprn_summary

2091: --
2092: CURSOR c_get_init_rsv IS
2093: SELECT ytd_deprn
2094: , deprn_reserve
2095: FROM fa_deprn_summary
2096: WHERE asset_id = p_asset_id
2097: AND book_type_code = p_book_type_code
2098: AND deprn_source_code = 'BOOKS';
2099:

Line 2449: -- Get reserve entry from fa_adjustments and fa_deprn_summary(b row)

2445: end if; -- (l_process_this_trx)
2446: END LOOP; -- i in 1..tt_transaction_header_id.count
2447:
2448: --
2449: -- Get reserve entry from fa_adjustments and fa_deprn_summary(b row)
2450: --
2451:
2452: l_asset_hdr_rec.asset_id := p_asset_id;
2453: l_asset_hdr_rec.period_of_addition := null;

Line 3520: -- Get reserve entry from fa_adjustments and fa_deprn_summary(b row)

3516: fa_debug_pkg.add(l_calling_fn,'Rec returned from c_get_bst', fa_amort_pvt.t_period_counter.count, p_log_level_rec => p_log_level_rec);
3517: end if;
3518:
3519: --
3520: -- Get reserve entry from fa_adjustments and fa_deprn_summary(b row)
3521: --
3522:
3523: l_asset_hdr_rec.asset_id := t_asset_id(j);
3524: l_asset_hdr_rec.period_of_addition := null;