51: dp.latest_reval_cost,
52: dp.deprn_period,
53: dp.deprn_ytd,
54: substr(dp.asset_exception,1,30) exception_code
55: FROM igi_iac_proj_details dp,
56: fa_additions fad,
57: fa_categories fc
58: WHERE dp.projection_id = n_proj_id
59: AND fad.asset_id = dp.asset_id
403: -- 02-Oct-2003, Bug 3140574, delete from main projections tables
404: DELETE FROM igi_iac_projections
405: WHERE projection_id = p_projection_id;
406:
407: DELETE FROM igi_iac_proj_details
408: WHERE projection_id = p_projection_id;
409:
410: retcode := 0;
411: errbuf := 'RXi Projections Inner Wrapper Successful!';