APPS.EAM_CONSTRUCTION_EST_PVT dependencies on EAM_FAILURE_SETS

Line 4584: FROM eam_failure_set_associations efsa , eam_failure_sets efs

4580:
4581:
4582: SELECT efsa.failure_code_required
4583: INTO l_failure_required
4584: FROM eam_failure_set_associations efsa , eam_failure_sets efs
4585: WHERE efsa.inventory_item_id = l_item_id
4586: AND efsa.set_id = efs.set_id (+)
4587: AND (efsa.EFFECTIVE_END_DATE is null or efs.EFFECTIVE_END_DATE >= sysdate )
4588: AND ( efs.EFFECTIVE_END_DATE is null or efs.EFFECTIVE_END_DATE >=sysdate ) ;