BEGIN

    #Routine body goes here...

INSERT INTO EMS_PM_STORAGE (

    AMOID,

    GP_BEGIN_TIME,

    EMS_RECORD_TIME,

    ZDC_L_LODA

) SELECT

    epl.AMOID,

    epl.GP_BEGIN_TIME,

    TIMESTAMPDIFF(

        MINUTE,

        epl.GP_BEGIN_TIME,

        MAX(epl.LOG_TIME)

    ) - 15 RECORD_TIME2,

    TIMESTAMPDIFF(

        MINUTE,

        epr.GP_BEGIN_TIME,

        MAX(epr.RECORD_TIME)

    ) - 15 ZDC_L_LODA

FROM

    EMS_PM_LOG epl,EMS_PM_REPORT epr

WHERE

    epl.AMOID=epr.AMOID AND epl.GP_BEGIN_TIME=epr.GP_BEGIN_TIME

GROUP BY

    epl.AMOID,

    epr.GP_BEGIN_TIME;

END