SELECT EMP_NUMBER AS EMP_NUMBER,trn_processed_year AS MON_PRS_YEAR,trn_processed_month AS MON_PRS_MONTH,SUM(trn_processed_amt) TXP_PROC_CUR_BASE_EMP_AMT
FROM hs_pr_processedflattxn a,hs_pr_profile f
where TRN_DTL_CODE in ('FE0005')
and COALESCE(trn_processed_amt,0) > 0
and...