--sql_act is: 
SELECT B.PROJECT_ID, B.NC_EFF_STATUS, B.DESCR,
( SELECT SUM(A.POSTED_TOTAL_AMT)
  FROM PS_NC_LEDGER A
  WHERE A.BUSINESS_UNIT = 'NCSU1'
    AND A.LEDGER = 'ACTUALS'
    AND A.CURRENCY_CD = 'USD'
    AND A.FISCAL_YEAR=TO_NUMBER(TO_CHAR(ADD_MONTHS(TO_DATE('June 30, 2
+010','Month DD, YYYY'),6),'YYYY'))
    AND (A.ACCOUNTING_PERIOD <= TO_NUMBER(SUBSTR('07080910111201020304
+0506',
                  ((TO_CHAR(TO_DATE('June 30, 2010', 'Month DD, YYYY')
+,'MM')*2)-1),2))
                  OR A.ACCOUNTING_PERIOD = 998) 
    AND (A.ACCOUNT BETWEEN '50000' AND '59999')
    AND (A.NC_PROJECT_PROJREF = '059021')
    AND B.PROJECT_ID = A.PROJECT_ID
    AND B.NC_PROJECT_PROJREF = A.NC_PROJECT_PROJREF
)
FROM PS_NC_PROJ_ATTR_VW B
WHERE (B.NC_PROJECT_PROJREF = '059021')
  AND B.NC_EFFDT = (SELECT MAX(B2.NC_EFFDT) FROM PS_NC_PROJ_ATTR_VW B2
                    WHERE B2.PROJECT_ID = B.PROJECT_ID)
;

--sql_bud is: 
SELECT B.PROJECT_ID, B.NC_EFF_STATUS, B.DESCR,
( SELECT SUM(A.POSTED_TOTAL_AMT)
  FROM PS_NC_LEDGER_BUDG A
  WHERE A.BUSINESS_UNIT = 'NCSU1'
    AND A.LEDGER = 'BD_ACTUALS'
    AND A.FISCAL_YEAR=TO_NUMBER(TO_CHAR(ADD_MONTHS(TO_DATE('June 30, 2
+010','Month DD, YYYY'),6),'YYYY'))
    AND A.CURRENCY_CD = 'USD'
    AND A.SCENARIO IN ('CGLOAD','CG20','CG21','CI21','CN24','CN26','CY
+21','CY23','FN21')
    AND (A.ACCOUNTING_PERIOD <= TO_NUMBER(SUBSTR('07080910111201020304
+0506',
                 ((TO_CHAR(TO_DATE('June 30, 2010', 'Month DD, YYYY'),
+'MM')*2)-1),2))) 
    AND (A.ACCOUNT BETWEEN '50000' AND '59999')
    AND (A.NC_PROJECT_PROJREF = '059021')
    AND B.PROJECT_ID = A.PROJECT_ID
    AND B.NC_PROJECT_PROJREF = A.NC_PROJECT_PROJREF
)
FROM PS_NC_PROJ_ATTR_VW B
WHERE (B.NC_PROJECT_PROJREF = '059021')
  AND B.NC_EFFDT=(SELECT MAX(B2.NC_EFFDT) FROM PS_NC_PROJ_ATTR_VW B2
                  WHERE B2.PROJECT_ID= B.PROJECT_ID)
;

--sql_enc is: 
SELECT B.PROJECT_ID, B.NC_EFF_STATUS, B.DESCR,
( SELECT SUM(A.POSTED_TOTAL_AMT)
  FROM PS_NC_LEDGER_COM A
  WHERE A.BUSINESS_UNIT = 'NCSU1'
    AND (A.LEDGER = 'CC_ENC' OR A.LEDGER = 'CC_PREENC' OR A.LEDGER = '
+ACTUALS')
    AND A.CURRENCY_CD = 'USD'
    AND A.FISCAL_YEAR=TO_NUMBER(TO_CHAR(ADD_MONTHS(TO_DATE('June 30, 2
+010','Month DD, YYYY'),6),'YYYY'))
    AND (A.ACCOUNTING_PERIOD <= TO_NUMBER(SUBSTR('07080910111201020304
+0506',
                  ((TO_CHAR(TO_DATE('June 30, 2010', 'Month DD, YYYY')
+,'MM')*2)-1),2))
                  OR A.ACCOUNTING_PERIOD = 998) 
    AND (A.ACCOUNT BETWEEN '50000' AND '59999')
    AND (A.NC_PROJECT_PROJREF = '059021')
    AND B.NC_PROJECT_PROJREF = A.NC_PROJECT_PROJREF
    AND B.PROJECT_ID = A.PROJECT_ID
)
FROM PS_NC_PROJ_ATTR_VW B
WHERE (B.NC_PROJECT_PROJREF = '059021')
  AND B.NC_EFFDT=(SELECT MAX(B2.NC_EFFDT) FROM PS_NC_PROJ_ATTR_VW B2
                  WHERE B2.PROJECT_ID = B.PROJECT_ID)
;
[download]