DARTS : UM_PAYEARNS_VW

SELECT 
 A.COMPANY,
 A.PAYGROUP,
 A.PAY_END_DT,
 A.OFF_CYCLE,
 A.ERNCD,
 A.FISCAL_YEAR,
 A.ACCOUNTING_PERIOD,
 A.ACCT_CD,
 A.POSITION_NBR,
 A.JOBCODE,
 A.NAME,
 A.EMPLID,
 A.EMPL_RCD,
 A.EARNINGS,
 B.ACCT_CD,
 B.DESCR,
 B.DESCRSHORT,
 B.ACCOUNT,
 B.DEPTID_CF,
 B.PROJECT_ID,
 B.PRODUCT,
 B.FUND_CODE,
 B.PROGRAM_CODE,
 B.CLASS_FLD,
 B.AFFILIATE,
 B.OPERATING_UNIT,
 B.ALTACCT,
 B.BUDGET_REF,
 B.CHARTFIELD1,
 B.CHARTFIELD2,
 B.CHARTFIELD3,
 B.AFFILIATE_INTRA1,
 B.AFFILIATE_INTRA2,
 J.DESCR,
 J.DESCRSHORT,
 D.DESCR,
 E.DESCR,
 E.MANAGER_NAME,
 F.DESCR,
 G.DESCR,
 G.MANAGER_NAME,
 H.DESCR,
 I.DESCR
  FROM PS_UM_EARN_ACCT_VW   A,
       PS_ACCT_CD_TBL       B,
       FN_PS_UM_ACCT_EFF_VW D,
       FN_PS_UM_DEPT_EFF_VW E,
       FN_PS_UM_FUND_EFF_VW F,
       FN_PS_UM_PROG_EFF_VW G,
       FN_PS_UM_PROJ_EFF_VW H,
       FN_PS_UM_OPER_EFF_VW I,
       PS_EARNINGS_TBL      J
 WHERE /* A.COMPANY = 'UMS' AND */
 B.ACCT_CD = A.ACCT_CD /* AND
 B.FDM_COMBO_CD = A.ACCT_CD AND B.EFF_STATUS = 'A' AND B.EFFDT = (
 SELECT MAX(B2.EFFDT) FROM PS_VALID_COMBO_TBL B2 WHERE B.SETID =
 B2.SETID AND B.FDM_COMBO_CD = B2.FDM_COMBO_CD AND B.EFF_STATUS =
 B2.EFF_STATUS AND B2.EFFDT <= TO_DATE(TO_CHAR(SYSDATE,'YYYY-MM-DD')
,'YYYY-MM-DD')) */
 AND J.
 ERNCD = A.ERNCD /* AND J.EFF_STATUS = 'A' */
 AND J.EFFDT =
 (SELECT MAX(J2.EFFDT)
    FROM PS_EARNINGS_TBL J2
   WHERE J.ERNCD = J2.ERNCD /* AND J.EFF_STATUS = J2.EFF_STATUS */
     AND J2.EFFDT <= TO_DATE(TO_CHAR(SYSDATE, 'YYYY-MM-DD'), 'YYYY-MM-DD'))
 AND B.ACCOUNT = D.ACCOUNT /* AND D.UM_EFF_STATUS = 'A' */
 AND B.DEPTID_CF = E.DEPTID(+) /* AND (E.UM_EFF_STATUS = 'A' OR E.UM_EFF_STATUS IS
 NULL) */
 AND B.FUND_CODE = F.FUND_CODE(+) /*AND (F.UM_EFF_STATUS =
 'A' OR F.UM_EFF_STATUS IS NULL) */
 AND B.PROGRAM_CODE = G.PROGRAM_CODE(+) /*AND (G.UM_EFF_STATUS = 'A' OR G.UM_EFF_STATUS IS
 NULL) */
 AND B.PROJECT_ID = H.PROJECT_ID(+) /*AND (H.UM_EFF_STATUS =
 'A' OR H .UM_EFF_STATUS IS NULL) */
 AND B.OPERATING_UNIT = I.OPERATING_UNIT(+) /*AND (I.UM_EFF_STATUS = 'A' OR I.UM_EFF_STATUS
 IS NULL)*/
;