UPDATE dbo.PL_TRADEDETAIL SET AMT_APP=ROUND(AMT_APP,0)
UPDATE dbo.PL_TRADEDETAIL SET PRICE=ROUND(PRICE,0)
UPDATE dbo.PL_IMPORT_DT SET TOTAL_AMT=ROUND(TOTAL_AMT,0)
UPDATE dbo.PL_TRADEDETAIL_HIST SET AMT_APP=ROUND(AMT_APP,0)
UPDATE dbo.PL_MASTER SET TOTAL_AMT=(SELECT SUM(AMT_APP) FROM dbo.PL_TRADEDETAIL WHERE PL_TRADEDETAIL.PLAN_ID=PL_MASTER.PLAN_ID)