417: WHERE NVL(EFC2.EFFECTIVE_END_DATE, SYSDATE) >= SYSDATE
418: AND EFC2.SET_ID = EFSA.SET_ID
419: )
420: AND exists ( SELECT 'x'
421: FROM EAM_FAILURE_SETS EFS
422: WHERE NVL(EFS.EFFECTIVE_END_DATE, SYSDATE) >= SYSDATE
423: AND EFS.SET_ID = EFSA.SET_ID
424: )
425: AND rownum = 1;
455: WHERE nvl(EFC2.effective_end_date, sysdate) >= sysdate
456: AND EFC2.set_id = EFSA.set_id
457: )
458: AND SYSDATE <= ( SELECT min(nvl(EFS.EFFECTIVE_END_DATE, SYSDATE))
459: FROM EAM_FAILURE_SETS EFS
460: WHERE nvl(EFS.EFFECTIVE_END_DATE, SYSDATE) >= sysdate
461: AND EFS.SET_ID = EFSA.SET_ID
462: );
463: IF l_valid_cause_code = 0 THEN
491: WHERE nvl(EFC2.effective_end_date, sysdate) >= sysdate
492: AND EFC2.set_id = EFSA.set_id
493: )
494: AND SYSDATE <= ( SELECT min(nvl(EFS.EFFECTIVE_END_DATE, SYSDATE))
495: FROM EAM_FAILURE_SETS EFS
496: WHERE nvl(EFS.EFFECTIVE_END_DATE, SYSDATE) >= sysdate
497: AND EFS.SET_ID = EFSA.SET_ID
498: );
499:
791: WHERE nvl(EFC2.effective_end_date, sysdate) >= sysdate
792: AND EFC2.set_id = EFSA.set_id
793: )
794: AND SYSDATE <= ( SELECT min(nvl(EFS.EFFECTIVE_END_DATE, SYSDATE))
795: FROM EAM_FAILURE_SETS EFS
796: WHERE nvl(EFS.EFFECTIVE_END_DATE, SYSDATE) >= sysdate
797: AND EFS.SET_ID = EFSA.SET_ID
798: );
799: EXCEPTION