SELECT FA. PERSON_ID ,SUM(NVL(AWD.OFFERED_AMT,0)) ,SUM(NVL(AWD.ACCEPTED_AMT,0)) ,SUM(NVL(AWD.PAID_AMT,0)) FROM IGF_AW_AWARD AWD , IGF_AP_FA_BASE_REC FA WHERE AWD.BASE_ID = FA.BASE_ID AND AWD.AWARD_STATUS IN ('OFFERED', 'ACCEPTED') GROUP BY FA.PERSON_ID
SELECT FA. PERSON_ID
, SUM(NVL(AWD.OFFERED_AMT
, 0))
, SUM(NVL(AWD.ACCEPTED_AMT
, 0))
, SUM(NVL(AWD.PAID_AMT
, 0))
FROM IGF_AW_AWARD AWD
, IGF_AP_FA_BASE_REC FA
WHERE AWD.BASE_ID = FA.BASE_ID
AND AWD.AWARD_STATUS IN ('OFFERED'
, 'ACCEPTED') GROUP BY FA.PERSON_ID
|
|
|