CREATE OR REPLACE TRIGGER "DO_DCMBL".FFF_ACHIEVE_Tr AFTER
    INSERT
    ON Master_Sales_Tbl
    FOR EACH ROW
BEGIN
  IF INSERTING THEN
declare
 emp_id varchar2(20);
 percentage number(10,2);
begin
 select emp_id, percentage into emp_id, percentage from field_force_tbl
 where :master_sales.party_code=field_force_tbl.distributor_id;
    UPDATE Do_Dcmbl.FIELD_Achievement_Tbl
     SET Achieved_Qty_Monthly =
  nvl(Achieved_Qty_Monthly,0) + (:New.product_quantity*percentage/100), 
Achieved_Amt_Monthly = 
  nvl(Achieved_Amt_Monthly,0) + (:New.Sales_amount*percentage/100)
      WHERE  FIELD_Achievement_Tbl.product_Code =:New.product_Code AND
 FIELD_Achievement_Tbl.emp_id=field_force_tbl.emp_id AND
 FIELD_Achievement_Tbl.DISTRIBUTOR_code=:New.DISTRIBUTOR_CODE AND
 FIELD_Achievement_Tbl.MONTH_ID=:New.MONTH_ID AND
 FIELD_Achievement_Tbl.TARGET_YEAR=:New.YEAR;

  END IF;
  END;

END;
/