APPS.FA_ASSET_VAL_PVT dependencies on FA_RETIREMENTS

Line 1177: FA_RETIREMENTS RET

1173: < p_date_placed_in_service
1174: UNION
1175: SELECT TH.TRANSACTION_HEADER_ID
1176: FROM FA_TRANSACTION_HEADERS TH,
1177: FA_RETIREMENTS RET
1178: WHERE TH.ASSET_ID = p_asset_id
1179: AND TH.BOOK_TYPE_CODE = p_book_type_code
1180: AND TH.TRANSACTION_TYPE_CODE IN
1181: ('FULL RETIREMENT', 'PARTIAL RETIREMENT')

Line 2787: from fa_retirements

2783: BEGIN
2784:
2785: select count(*)
2786: into l_count
2787: from fa_retirements
2788: where book_type_code = p_book
2789: and asset_id = p_asset_id
2790: and status in ('PENDING','REINSTATE');
2791:

Line 3465: FROM fa_retirements ret

3461: NVL(th.amortization_start_date, th.transaction_date_entered))
3462: <= p_transaction_date
3463: AND NOT EXISTS
3464: (SELECT 'Exclude Retirement which reinstatement exists'
3465: FROM fa_retirements ret
3466: ,fa_transaction_headers reith
3467: WHERE ret.transaction_header_id_in = th.transaction_header_id
3468: AND ret.transaction_header_id_out = reith.transaction_header_id
3469: AND NVL(reith.amortization_start_date, reith.transaction_date_entered)

Line 3498: FROM fa_retirements ret

3494: AND th.transaction_header_id <> p_transaction_header_id
3495: AND inbk.date_placed_in_service <= p_transaction_date
3496: AND NOT EXISTS
3497: (SELECT 'Exclude Retirement which reinstatement exists'
3498: FROM fa_retirements ret
3499: ,fa_transaction_headers reith
3500: WHERE ret.transaction_header_id_in = th.transaction_header_id
3501: AND ret.transaction_header_id_out = reith.transaction_header_id
3502: AND NVL(reith.amortization_start_date, reith.transaction_date_entered)

Line 3538: FROM fa_retirements ret

3534: NVL(th.amortization_start_date, th.transaction_date_entered))
3535: <= p_transaction_date
3536: AND NOT EXISTS
3537: (SELECT 'Exclude Retirement which reinstatement exists'
3538: FROM fa_retirements ret
3539: ,fa_transaction_headers reith
3540: WHERE ret.transaction_header_id_in = th.transaction_header_id
3541: AND ret.transaction_header_id_out = reith.transaction_header_id
3542: AND NVL(reith.amortization_start_date, reith.transaction_date_entered)

Line 3571: FROM fa_retirements ret

3567: AND th.transaction_header_id <> p_transaction_header_id
3568: AND inbk.date_placed_in_service <= p_transaction_date
3569: AND NOT EXISTS
3570: (SELECT 'Exclude Retirement which reinstatement exists'
3571: FROM fa_retirements ret
3572: ,fa_transaction_headers reith
3573: WHERE ret.transaction_header_id_in = th.transaction_header_id
3574: AND ret.transaction_header_id_out = reith.transaction_header_id
3575: AND NVL(reith.amortization_start_date, reith.transaction_date_entered)

Line 5821: from fa_retirements ret,

5817: /* Cursor to get last pending retirment for the group */
5818: cursor c_last_ret_mem_details is
5819: select ad.asset_id, ad.asset_number,
5820: ret.transaction_header_id_in
5821: from fa_retirements ret,
5822: fa_additions_b ad
5823: where ret.book_type_code = p_asset_retire_rec.detail_info.book_type_code
5824: and ad.asset_id = ret.asset_id
5825: and ret.transaction_header_id_in =

Line 5827: from fa_retirements far,

5823: where ret.book_type_code = p_asset_retire_rec.detail_info.book_type_code
5824: and ad.asset_id = ret.asset_id
5825: and ret.transaction_header_id_in =
5826: (select max(far.transaction_header_id_in)
5827: from fa_retirements far,
5828: fa_books bk
5829: where far.book_type_code = p_asset_retire_rec.detail_info.book_type_code
5830: and far.asset_id = bk.asset_id
5831: and bk.book_type_code = p_asset_retire_rec.detail_info.book_type_code

Line 7039: from fa_retirements

7035: from dual
7036: where exists
7037: (
7038: select 1
7039: from fa_retirements
7040: where book_type_code = p_asset_hdr_rec.book_type_code
7041: and asset_id = p_asset_hdr_rec.asset_id
7042: and status = 'PROCESSED'
7043: );