CREATE OR REPLACE EDITIONABLE TRIGGER "AC_ACCRUED_PREMIUM_GEN_TRG" 
AFTER INSERT ON AC_ACCRUED_PREMIUM_GEN  
FOR EACH ROW
BEGIN
	          INSERT INTO AC_ACCRUED_PREMIUM_PLAN_GEN
                SELECT 
                	:NEW.ISLEM_NO AS PREMIUM_GEN_ID ,
                	:NEW.KAYNAK_ID AS TRANSACTION_ID,
                	P.ID AS POLICY_ID,
                	P_HEALTH.GROUP_HEALTH_PLAN_ID,
                	P.COMPANY_SHARE_PERCENT,
                	PA.REINSURANCE_COMMISSION_RATE,
                	SUM(ENT.AMOUNT) AS TOTAL_PREMIUM_OF_PLAN,
                	(SUM(ENT.AMOUNT) * P.COMPANY_SHARE_PERCENT/100) AS COMPANY_SHARE_AMOUNT,
                	(SUM(ENT.AMOUNT) * PA.REINSURANCE_COMMISSION_RATE /100) AS REINSURANCE_COMMISSION_AMOUNT,
                	PA.AS_ISSUE_DATE,
                	SYSDATE AS CREATE_DATE
                FROM  AC_ENTRY ENT   
                INNER JOIN P_POLICY P ON P.ID = ENT.POLICY_ID AND ENT.SUPER_ENTRY_TYPE IN (3,4) AND ENT.TRANSACTION_TYPE_ID IN (1,50,51)  
                INNER JOIN P_POLICY_ANDL PA ON PA.ID = P.ID
                INNER JOIN P_POLICY_LOB P_LOB ON P.ID = P_LOB.POLICY_ID 
                INNER JOIN P_POLICY_LOB_TO_LOB_ASSET L_ASSET ON L_ASSET.POLICY_LOB_ID = P_LOB.ID
                INNER JOIN P_POLICY_LOB_ASSET P_ASSET ON P_ASSET.ID = L_ASSET.LOB_ASSET_ID AND P_ASSET.ORIGINAL_LOB_ASSET_ID = ENT.ORIGINAL_LOB_ASSET_ID
                INNER JOIN AS_ASSET A_ASSET ON A_ASSET.ID = P_ASSET.LOB_ASSET_ID
                INNER JOIN AS_PERSON A_PERSON ON  A_ASSET.ID=A_PERSON.ASSET_ID 
                INNER JOIN AS_PERSON_HEALTH_ANDL P_HEALTH ON A_PERSON.ID=P_HEALTH.PERSON_ID   
                WHERE ENT.TRANSACTION_ID = :NEW.KAYNAK_ID
                GROUP BY  
                		 P.ID, 
                	 	 P_HEALTH.GROUP_HEALTH_PLAN_ID,
                		 P.COMPANY_SHARE_PERCENT,
                		 PA.REINSURANCE_COMMISSION_RATE,
                		 PA.AS_ISSUE_DATE;
END;

select * from v$version;
show user