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_RETIREMENTS

Line 1488: FROM fa_retirements ret

1484:
1485: Cursor retirements ( transaction_id NUMBER) IS
1486:
1487: SELECT nvl(ret.cost_retired,0)
1488: FROM fa_retirements ret
1489: WHERE ret.transaction_header_id_in (+) = transaction_id
1490: ;
1491:
1492: Cursor Get_reinstatement_Details ( transaction_id NUMBER) IS

Line 1498: FROM fa_retirements ret,

1494: SELECT DECODE(fth.transaction_type_code, 'FULL_RETIREMENT','F',
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