2074: ,px_asset_retire_rec.reserve_retired
2075: ,px_asset_retire_rec.eofy_reserve
2076: ,px_asset_retire_rec.reduction_rate
2077: ,px_asset_retire_rec.detail_info.recapture_amount
2078: ,px_asset_retire_rec.detail_info.row_id -- used as parameter when calling fa_retirements_pkg.delete
2079: from fa_retirements_mrc_v
2080: where retirement_id = px_asset_retire_rec.retirement_id;
2081:
2082: else
2075: ,px_asset_retire_rec.eofy_reserve
2076: ,px_asset_retire_rec.reduction_rate
2077: ,px_asset_retire_rec.detail_info.recapture_amount
2078: ,px_asset_retire_rec.detail_info.row_id -- used as parameter when calling fa_retirements_pkg.delete
2079: from fa_retirements_mrc_v
2080: where retirement_id = px_asset_retire_rec.retirement_id;
2081:
2082: else
2083:
2184: ,px_asset_retire_rec.reserve_retired
2185: ,px_asset_retire_rec.eofy_reserve
2186: ,px_asset_retire_rec.reduction_rate
2187: ,px_asset_retire_rec.detail_info.recapture_amount
2188: ,px_asset_retire_rec.detail_info.row_id -- used as parameter when calling fa_retirements_pkg.delete
2189: from fa_retirements
2190: where retirement_id = px_asset_retire_rec.retirement_id;
2191:
2192: end if;
2185: ,px_asset_retire_rec.eofy_reserve
2186: ,px_asset_retire_rec.reduction_rate
2187: ,px_asset_retire_rec.detail_info.recapture_amount
2188: ,px_asset_retire_rec.detail_info.row_id -- used as parameter when calling fa_retirements_pkg.delete
2189: from fa_retirements
2190: where retirement_id = px_asset_retire_rec.retirement_id;
2191:
2192: end if;
2193: