|
SELECT D.BUSINESS_UNIT , D.CONTRACT_NUM , SUM(A.SPONSOR_AMT) FROM PS_GM_EC_BUD_DTL A , PS_GM_BUD_PERIOD B , PS_GM_AWARD D WHERE A.BUSINESS_UNIT = D.BUSINESS_UNIT AND A.PROPOSAL_ID = D.PROPOSAL_ID AND A.VERSION_ID = D.VERSION_ID AND B.BEGIN_DT <= %CurrentDateIn AND B.END_DT >= %CurrentDateIn AND A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.PROPOSAL_ID = B.PROPOSAL_ID AND A.VERSION_ID = B.VERSION_ID AND A.SUB_PROP_NBR = B.SUB_PROP_NBR AND A.BUDGET_ID = B.BUDGET_ID AND A.BUDGET_PERIOD_GM = B.BUDGET_PERIOD_GM GROUP BY D.BUSINESS_UNIT , D.CONTRACT_NUM
|