APPS.FA_ASSET_VAL_PVT dependencies on FA_RETIREMENTS

Line 965: FA_RETIREMENTS RET

961: < p_date_placed_in_service
962: UNION
963: SELECT TH.TRANSACTION_HEADER_ID
964: FROM FA_TRANSACTION_HEADERS TH,
965: FA_RETIREMENTS RET
966: WHERE TH.ASSET_ID = p_asset_id
967: AND TH.BOOK_TYPE_CODE = p_book_type_code
968: AND TH.TRANSACTION_TYPE_CODE IN
969: ('FULL RETIREMENT', 'PARTIAL RETIREMENT')

Line 2575: from fa_retirements

2571: BEGIN
2572:
2573: select count(*)
2574: into l_count
2575: from fa_retirements
2576: where book_type_code = p_book
2577: and asset_id = p_asset_id
2578: and status in ('PENDING','REINSTATE');
2579:

Line 3261: from fa_retirements ret,

3257: 'EXPENSED', inbk.date_placed_in_service,
3258: nvl(th.amortization_start_date,
3259: th.transaction_date_entered))) <= p_transaction_date
3260: and not exists(select 'Exclude Retirement which reinstatement exists'
3261: from fa_retirements ret,
3262: fa_transaction_headers reith
3263: where ret.transaction_header_id_in = th.transaction_header_id
3264: and ret.transaction_header_id_out = reith.transaction_header_id
3265: and nvl(reith.amortization_start_date,

Line 3300: from fa_retirements ret,

3296: 'EXPENSED', inbk.date_placed_in_service,
3297: nvl(th.amortization_start_date,
3298: th.transaction_date_entered))) <= p_transaction_date
3299: and not exists(select 'Exclude Retirement which reinstatement exists'
3300: from fa_retirements ret,
3301: fa_transaction_headers reith
3302: where ret.transaction_header_id_in = th.transaction_header_id
3303: and ret.transaction_header_id_out = reith.transaction_header_id
3304: and nvl(reith.amortization_start_date,