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 272: FROM fa_transaction_headers fth,

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

Line 301: fa_transaction_headers fth,

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

Line 457: FROM fa_transaction_headers fth,

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

Line 1499: fa_transaction_headers fth,

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