APPS.FA_C_INSURE dependencies on FA_BOOKS

Line 247: fa_books bks,

243: pol.value_before_retirement,
244: nvl(pol.last_price_index_value,pii.price_index_value),
245: bks.period_counter_fully_reserved
246: FROM fa_additions fad,
247: fa_books bks,
248: fa_ins_policies pol,
249: fa_ins_mst_pols mpol,
250: fa_price_index_values pii
251: WHERE fad.asset_number BETWEEN NVL(p_asset_start, fad.asset_number)

Line 283: fa_books bks

279: fth.transaction_header_id,
280: fth.transaction_date_entered,
281: bks.cost
282: FROM fa_transaction_headers fth,
283: fa_books bks
284: WHERE bks.date_ineffective is not null
285: AND fth.transaction_date_entered BETWEEN
286: nvl(pol_day_after_indexation,fth.transaction_date_entered)
287: AND last_period_closed_date

Line 312: fa_books bks

308: 'CR', -1 * nvl(adj.adjustment_amount,0),
309: NVL(adj.adjustment_amount,0))
310: FROM fa_adjustments adj,
311: fa_transaction_headers fth,
312: fa_books bks
313: WHERE bks.date_ineffective is not null
314: AND fth.transaction_date_entered BETWEEN
315: nvl(pol_day_after_indexation,fth.transaction_date_entered)
316: AND last_period_closed_date

Line 462: fa_books bks

458:
459: Select count(*)
460: Into num_loops
461: FROM fa_transaction_headers fth,
462: fa_books bks
463: WHERE bks.date_ineffective is not null
464: AND fth.transaction_date_entered BETWEEN
465: nvl(pol_day_after_indexation,fth.transaction_date_entered)
466: AND last_period_closed_date

Line 703: FROM fa_books bks,

699: last_period_closed NUMBER
700: ) IS
701: SELECT bks.cost- fdd.deprn_reserve,
702: fdd.ytd_deprn
703: FROM fa_books bks,
704: fa_deprn_summary fdd
705: WHERE bks.book_type_code = fdd.book_type_code
706: AND bks.asset_id = fdd.asset_id
707: AND fdd.asset_id = pol_asset_id

Line 749: FROM fa_books bks,

745: bks.life_in_months -
746: floor(months_between(fdp.calendar_period_close_date,
747: bks.date_placed_in_service))
748: asset_remaining_life
749: FROM fa_books bks,
750: fa_deprn_periods fdp
751: WHERE bks.book_type_code = P_asset_book
752: AND fdp.book_type_code = P_asset_book
753: AND bks.book_type_code = fdp.book_type_code

Line 770: FROM fa_books bks,

766:
767: SELECT (bks.life_in_months -
768: floor(months_between(fdp.calendar_period_close_date,
769: bks.date_placed_in_service)+1))
770: FROM fa_books bks,
771: fa_deprn_periods fdp
772: WHERE bks.book_type_code = P_asset_book
773: AND fdp.book_type_code = P_asset_book
774: AND bks.asset_id = pol_asset_id

Line 1490: fa_books bks

1486: nvl(ret.cost_retired,0),
1487: nvl(bks.cost,0)
1488: FROM fa_retirements ret,
1489: fa_transaction_headers fth,
1490: fa_books bks
1491: WHERE ret.transaction_header_id_out = transaction_id
1492: AND ret.transaction_header_id_in = fth.transaction_header_id
1493: AND bks.transaction_header_id_out = fth.transaction_header_id
1494: ;