INSERT INTO
xx.yyyy
(
CLIENT_CD,
CYCLE_ID,
PROVIDER_ID,
CLAIM_FORM_CD,
REC_CNT,
TOT_PAID_AMT,
LAST_UPDATE_NM,
LAST_UPDATE_DTM
)
SELECT client_cd, v_cycle_id, BILL_PROVIDER_ID, CLAIM_FORM_CD,
COUNT(*), sum(ma_paid_amt), v_update_nm,
current timestamp
FROM xx.yyyy_dtl
WHERE CLIENT_CD=i_client_cd AND
CYCLE_ID = v_cycle_id AND
LINE_STATUS_CD='NOEDIT'
GROUP BY CLIENT_CD,CYCLE_ID,BILL_PROVIDER_ID,CLAIM_FORM_CD;