[Home] [Help]
233: pol.value_before_retirement,
234: nvl(pol.last_price_index_value,pii.price_index_value),
235: bks.period_counter_fully_reserved
236: FROM fa_additions fad,
237: fa_books bks,
238: fa_ins_policies pol,
239: fa_ins_mst_pols mpol,
240: fa_price_index_values pii
241: WHERE fad.asset_number BETWEEN NVL(p_asset_start, fad.asset_number)
269: fth.transaction_header_id,
270: fth.transaction_date_entered,
271: bks.cost
272: FROM fa_transaction_headers fth,
273: fa_books bks
274: WHERE bks.date_ineffective is not null
275: AND fth.transaction_date_entered BETWEEN
276: nvl(pol_day_after_indexation,fth.transaction_date_entered)
277: AND last_period_closed_date
298: 'CR', -1 * nvl(adj.adjustment_amount,0),
299: NVL(adj.adjustment_amount,0))
300: FROM fa_adjustments adj,
301: fa_transaction_headers fth,
302: fa_books bks
303: WHERE bks.date_ineffective is not null
304: AND fth.transaction_date_entered BETWEEN
305: nvl(pol_day_after_indexation,fth.transaction_date_entered)
306: AND last_period_closed_date
454:
455: Select count(*)
456: Into num_loops
457: FROM fa_transaction_headers fth,
458: fa_books bks
459: WHERE bks.date_ineffective is not null
460: AND fth.transaction_date_entered BETWEEN
461: nvl(pol_day_after_indexation,fth.transaction_date_entered)
462: AND last_period_closed_date
702: last_period_closed NUMBER
703: ) IS
704: SELECT bks.cost- fdd.deprn_reserve,
705: fdd.ytd_deprn
706: FROM fa_books bks,
707: fa_deprn_summary fdd
708: WHERE bks.book_type_code = fdd.book_type_code
709: AND bks.asset_id = fdd.asset_id
710: AND fdd.asset_id = pol_asset_id
747: bks.life_in_months -
748: floor(months_between(fdp.calendar_period_close_date,
749: bks.date_placed_in_service))
750: asset_remaining_life
751: FROM fa_books bks,
752: fa_deprn_periods fdp
753: WHERE bks.book_type_code = P_asset_book
754: AND fdp.book_type_code = P_asset_book
755: AND bks.book_type_code = fdp.book_type_code
768:
769: SELECT (bks.life_in_months -
770: floor(months_between(fdp.calendar_period_close_date,
771: bks.date_placed_in_service)+1))
772: FROM fa_books bks,
773: fa_deprn_periods fdp
774: WHERE bks.book_type_code = P_asset_book
775: AND fdp.book_type_code = P_asset_book
776: AND bks.asset_id = pol_asset_id
1496: nvl(ret.cost_retired,0),
1497: nvl(bks.cost,0)
1498: FROM fa_retirements ret,
1499: fa_transaction_headers fth,
1500: fa_books bks
1501: WHERE ret.transaction_header_id_out = transaction_id
1502: AND ret.transaction_header_id_in = fth.transaction_header_id
1503: AND bks.transaction_header_id_out = fth.transaction_header_id
1504: ;