[Home] [Help]
98: -- asset has to start to be adjusted. --
99: ------------------------------------------------------------
100:
101: CURSOR adjustable_assets(l_country_code IN VARCHAR2) IS
102: -- SELECT /*+ leading(b) index(th FA_TRANSACTION_HEADERS_U1) */ a.asset_id,
103: SELECT a.asset_id,
104: a.asset_category_id,
105: a.asset_type,
106: NVL(FND_DATE.CANONICAL_TO_DATE(a.global_attribute1),b.date_placed_in_service) revaluation_start_date,
110: FROM
111: fa_category_books c
112: , fa_additions a
113: , fa_books b
114: , fa_transaction_headers th
115: WHERE b.book_type_code = p_book_type_code
116: AND b.cost <> 0
117: AND b.global_attribute1 = 'Y'
118: AND b.date_ineffective IS NULL
131: -- Bug 12737275 End
132: AND th.transaction_header_id <= b.transaction_header_id_in
133: AND ((g_revalue_cip_assets_flag is NULL AND a.asset_type = 'CAPITALIZED')
134: OR (g_revalue_cip_assets_flag is NOT NULL))
135: AND not exists (select 'X' from FA_TRANSACTION_HEADERS th_2
136: where th_2.book_type_code = p_book_type_code
137: AND th_2.asset_id = a.asset_id
138: AND th_2.transaction_type_code = 'REVALUATION'
139: AND th_2.date_effective >= g_period_open_date)
523: BEGIN
524: SELECT min(dp.period_counter)
525: INTO dummy
526: FROM fa_deprn_periods dp
527: , fa_transaction_headers th
528: , fa_asset_history ah
529: WHERE ah.asset_id = th.asset_id
530: AND dp.book_type_code = th.book_type_code
531: AND th.transaction_header_id >= ah.transaction_header_id_in
566: BEGIN
567:
568: SELECT cost_retired,date_retired
569: INTO p_amount,p_date_retired
570: FROM fa_transaction_headers b,
571: fa_retirements a
572: WHERE a.book_type_code = p_book_type_code
573: AND a.asset_id = p_asset_id
574: AND a.status = 'DELETED'