eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FA_C_INSURE dependencies on FA_TRANSACTION_HEADERS

Line 282: FROM fa_transaction_headers fth,

278: 'REINSTATEMENT', 'R', 'A'),
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)

Line 311: fa_transaction_headers fth,

307: SELECT DECODE(adj.DEBIT_CREDIT_FLAG ,
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)

Line 461: FROM fa_transaction_headers fth,

457: (pol_calculation_method = 'CMV' and pol_swiss_building = 'Y') THEN
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)

Line 1489: fa_transaction_headers fth,

1485: 'PARTIAL RETIREMENT','P','R'),
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