HELP!! With eff date logic

[Rick_Creel@AONCONS.COM]

My environment:
PeopleSoft  ver  7.53
Oracle   ver  8.06  (rule based)
SQR  4.34

I have this rather complex query that will work WITHOUT eff date logic, it
returns one row of data.
However, if I include eff date logic, it returns zero rows of data.  I can run a
very simple query using the eff date logic and it returns the name, as it
should.  My query is below.  Right now I have the eff date logic that is giving
the error between  /*  */

Can anyone PLEASE help.... tell my why the eff date logic returns 0 rows????

TIA

--------------------------------------

SELECT E.PROCESS_INSTANCE, E.BUSINESS_UNIT, E.INVOICE, E.PRINT_SEQ_NBR,
TO_CHAR(E.INVOICE_DT,'YYYY-MM-DD'), E.PYMNT_TERMS_CD_DSC, E.DISC_AMT,
 TO_CHAR(E.DISC_DT,'YYYY-MM-DD'), TO_CHAR(E.DUE_DT,'YYYY-MM-DD'), E.CUST_ID,
 B.BILL_TO_CUST_ID, B.BILL_INQUIRY_PHONE, B.INVOICE_AMT_XEU, B.CURRENCY_CD_XEU,
 C.INVOICE_LINE, C.LINE_SEQ_NUM, C.DESCR, C.NET_EXTENDED_AMT,
C.TOT_DISCOUNT_AMT,
C.ACTIVITY_ID, C.RESOURCE_TYPE, C.RESOURCE_CATEGORY, C.RESOURCE_SUB_CAT, C.QTY,
 C.UNIT_OF_MEASURE, C.UNIT_AMT, C.TAX_AMT, C.GROSS_EXTENDED_AMT, C.CONTRACT_NUM,
 C.PROJECT_ID, E.POSTAL, E.COUNTRY, E.ADDR_LN1, E.ADDR_LN2, E.ADDR_LN3,
E.ADDR_LN4,
 E.ADDR_LN5, E.ADDR_LN6, E.ADDR_LN7, E.ADDR_LN8, E.CUSTOM_LABEL, E.INV_LABEL,
E.INVOICE_LAYOUT_ID, E.REMIT_POSTAL, E.REMIT_COUNTRY, E.REMIT_ADDR_LN1,
E.REMIT_ADDR_LN2, E.REMIT_ADDR_LN3, E.REMIT_ADDR_LN4, E.REMIT_ADDR_LN5,
E.REMIT_ADDR_LN6, E.REMIT_ADDR_LN7, E.REMIT_ADDR_LN8, E.CONSOL_BUS_UNIT,
 E.CONSOL_INVOICE, E.XEU_PARTICIPATING, E.DECIMAL_POSITIONS, E.CURRENCY_CD,
C.VAT_AMT, B.DOC_SEQ_NBR, B.VAT_ENTITY, E.LANGUAGE_CD, B.PAID_AMT,
B.FORWARD_BAL_AMT,
 B.FORWARD_BAL_XEU, B.PAID_AMT_XEU, C.ADJ_LINE_TYPE, B.INVOICE_TYPE,
B.ORIGINAL_INVOICE,
 B.PRIOR_ADJ_INVOICE, B.COUNTRY_SHIP_FROM,  B.PAID_AMT*(-1), A.NAME1,
  C.TOT_LINE_DST_AMT+ C.TOT_SURCHARGE_AMT,  substr( C.IDENTIFIER,1,4),
 F.ADDRESS1, F.ADDRESS2,   F.CITY || ' ' ||  F.STATE || '  ' ||  F.POSTAL,
 B.SHIP_TO_ADDR_NUM, B.SHIP_TO_CUST_ID, F.COUNTRY, I.TAX_AUTHORITY_CD,
J.DESCR254, I.TAX_AMT, K.TAX_AMT, L.TAX_AMT,J.SETID,J.BI_CURRENCY_CD,
J.CHARGE_ID,TO_CHAR(J.EFFDT,'YYYY-MM-DD')

FROM PS_BI_HDR B,
     PS_BI_LINE C,
     PS_RUN_BI_PRNTEXT D,
     PS_BI_EXTRCT E,
     PS_CUST_ADDRESS F,
     PS_CUST_CONTACT A,
     PS_BI_LINE_TAX_DTL I,
     PS_BI_CHARGE J,
     PS_BI_LINE_TAX_DTL K,
     PS_BI_LINE_TAX_DTL L
WHERE D.OPRID = 'CNDEVELO'
     AND D.RUN_CNTL_ID = 'CTE_REPRINT'
     AND E.PROCESS_INSTANCE BETWEEN D.FROM_PI AND D.TO_PI
     AND E.BUSINESS_UNIT = B.BUSINESS_UNIT
     AND E.INVOICE = B.INVOICE
     AND B.BUSINESS_UNIT = C.BUSINESS_UNIT
     AND B.INVOICE = C.INVOICE
     AND B.INVOICE_FORM_ID = 'CRYSTAL'
     AND E.CONSOL_HDR = 'N'
     AND E.CONSOL_BUS_UNIT = ' '
     AND B.SHIP_TO_ADDR_NUM =  F.ADDRESS_SEQ_NUM (+)
     AND B.SHIP_TO_CUST_ID =  F.CUST_ID(+)
     AND F.SETID = (SELECT H.SETID
                    FROM PS_OPR_DEF_TBL_FS H
                    WHERE H.OPRID = 'CNDEVELO')
     AND F.EFFDT = (SELECT MAX(F_ED.EFFDT) FROM PS_CUST_ADDRESS F_ED
                    WHERE F_ED.SETID           = F.SETID
                    AND   F_ED.CUST_ID         = F.CUST_ID
                    AND   F_ED.ADDRESS_SEQ_NUM = F.ADDRESS_SEQ_NUM
                    AND   F_ED.EFFDT          <= SYSDATE)
     AND A.SETID = F.SETID
     AND B.BILL_TO_CUST_ID =  A.CUST_ID(+)
     AND B.CNTCT_SEQ_NUM   =  A.CNTCT_SEQ_NUM(+)
     AND B.ADDRESS_SEQ_NUM =  A.ADDRESS_SEQ_NUM(+)
/*
AND A.EFFDT = (SELECT MAX(A_ED.EFFDT) FROM PS_CUST_CONTACT A_ED
               WHERE A_ED.SETID         = A.SETID
               AND   A_ED.CUST_ID       = A.CUST_ID
               AND   A_ED.CNTCT_SEQ_NUM = A.CNTCT_SEQ_NUM
               AND   A_ED.EFFDT        <= SYSDATE)
*/
     AND C.BUSINESS_UNIT =   I.BUSINESS_UNIT (+)
     AND C.INVOICE =  I.INVOICE (+)
     AND C.LINE_SEQ_NUM =  I.LINE_SEQ_NUM (+)
     AND   I.TAX_AUTHORITY_CD (+) = 'GST'
     AND C.BUSINESS_UNIT =  K.BUSINESS_UNIT (+)
     AND C.LINE_SEQ_NUM =  K.LINE_SEQ_NUM (+)
     AND C.INVOICE =  K.INVOICE (+)
     AND   K.TAX_AUTHORITY_CD (+) = 'QST'
     AND C.BUSINESS_UNIT =  L.BUSINESS_UNIT (+)
     AND C.INVOICE =  L.INVOICE (+)
     AND C.LINE_SEQ_NUM =  L.LINE_SEQ_NUM (+)
     AND   L.TAX_AUTHORITY_CD (+) = 'HST'
     AND J.DESCR = C.DESCR
ORDER BY 1, 4, 15