APPS.EAM_PROCESS_FAILURE_ENTRY_PVT dependencies on EAM_FAILURE_SETS

Line 420: FROM EAM_FAILURE_SETS EFS

416: WHERE nvl(EFC2.EFFECTIVE_END_DATE, SYSDATE) >= sysdate
417: AND EFC2.SET_ID = EFSA.SET_ID
418: )
419: AND sysdate <= ( SELECT min(nvl(EFS.EFFECTIVE_END_DATE, SYSDATE))
420: FROM EAM_FAILURE_SETS EFS
421: WHERE nvl(EFS.EFFECTIVE_END_DATE, SYSDATE) >= sysdate
422: AND EFS.SET_ID = EFSA.SET_ID
423: );
424: IF l_valid_failure_code = 0 THEN

Line 455: FROM EAM_FAILURE_SETS EFS

451: WHERE nvl(EFC2.effective_end_date, sysdate) >= sysdate
452: AND EFC2.set_id = EFSA.set_id
453: )
454: AND SYSDATE <= ( SELECT min(nvl(EFS.EFFECTIVE_END_DATE, SYSDATE))
455: FROM EAM_FAILURE_SETS EFS
456: WHERE nvl(EFS.EFFECTIVE_END_DATE, SYSDATE) >= sysdate
457: AND EFS.SET_ID = EFSA.SET_ID
458: );
459: IF l_valid_cause_code = 0 THEN

Line 491: FROM EAM_FAILURE_SETS EFS

487: WHERE nvl(EFC2.effective_end_date, sysdate) >= sysdate
488: AND EFC2.set_id = EFSA.set_id
489: )
490: AND SYSDATE <= ( SELECT min(nvl(EFS.EFFECTIVE_END_DATE, SYSDATE))
491: FROM EAM_FAILURE_SETS EFS
492: WHERE nvl(EFS.EFFECTIVE_END_DATE, SYSDATE) >= sysdate
493: AND EFS.SET_ID = EFSA.SET_ID
494: );
495:

Line 791: FROM EAM_FAILURE_SETS EFS

787: WHERE nvl(EFC2.effective_end_date, sysdate) >= sysdate
788: AND EFC2.set_id = EFSA.set_id
789: )
790: AND SYSDATE <= ( SELECT min(nvl(EFS.EFFECTIVE_END_DATE, SYSDATE))
791: FROM EAM_FAILURE_SETS EFS
792: WHERE nvl(EFS.EFFECTIVE_END_DATE, SYSDATE) >= sysdate
793: AND EFS.SET_ID = EFSA.SET_ID
794: );
795: EXCEPTION