2133: ,px_asset_retire_rec.reserve_retired
2134: ,px_asset_retire_rec.eofy_reserve
2135: ,px_asset_retire_rec.reduction_rate
2136: ,px_asset_retire_rec.detail_info.recapture_amount
2137: ,px_asset_retire_rec.detail_info.row_id -- used as parameter when calling fa_retirements_pkg.delete
2138: from fa_mc_retirements
2139: where retirement_id = px_asset_retire_rec.retirement_id
2140: and set_of_books_id = p_set_of_books_id;
2141:
2244: ,px_asset_retire_rec.reserve_retired
2245: ,px_asset_retire_rec.eofy_reserve
2246: ,px_asset_retire_rec.reduction_rate
2247: ,px_asset_retire_rec.detail_info.recapture_amount
2248: ,px_asset_retire_rec.detail_info.row_id -- used as parameter when calling fa_retirements_pkg.delete
2249: from fa_retirements
2250: where retirement_id = px_asset_retire_rec.retirement_id;
2251:
2252: end if;
2245: ,px_asset_retire_rec.eofy_reserve
2246: ,px_asset_retire_rec.reduction_rate
2247: ,px_asset_retire_rec.detail_info.recapture_amount
2248: ,px_asset_retire_rec.detail_info.row_id -- used as parameter when calling fa_retirements_pkg.delete
2249: from fa_retirements
2250: where retirement_id = px_asset_retire_rec.retirement_id;
2251:
2252: end if;
2253: