Insert into .. (select count(*),sum(xx

[Arun Srinivasan]

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_I D, CLAIM_FORM_CD,
COUNT(*), sum(ma_paid_amt ), v_update_nm,
current timestamp
FROM xx.yyyy_dtl
WHERE CLIENT_CD=i_cli ent_cd AND
CYCLE_ID = v_cycle_id AND
LINE_STATUS_CD= 'NOEDIT'
GROUP BY CLIENT_CD,CYCLE _ID,BILL_PROVID ER_ID,CLAIM_FOR M_CD;