APPS.FA_C_INSURE dependencies on FA_RETIREMENTS

Line 1478: FROM fa_retirements ret

1474:
1475: Cursor retirements ( transaction_id NUMBER) IS
1476:
1477: SELECT nvl(ret.cost_retired,0)
1478: FROM fa_retirements ret
1479: WHERE ret.transaction_header_id_in (+) = transaction_id
1480: ;
1481:
1482: Cursor Get_reinstatement_Details ( transaction_id NUMBER) IS

Line 1488: FROM fa_retirements ret,

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