APPS.EAM_PROCESS_FAILURE_ENTRY_PUB dependencies on EAM_WORK_ORDER_DETAILS

Line 721: FROM wip_discrete_jobs wdj, eam_work_order_details edw

717:
718: BEGIN
719: SELECT wdj.date_completed, nvl(edw.failure_code_required, 'N')
720: INTO l_date_completed , l_failure_code_required
721: FROM wip_discrete_jobs wdj, eam_work_order_details edw
722: WHERE wdj.wip_entity_id = edw.wip_entity_id
723: AND wdj.wip_entity_id = l_eam_failure_entry_record.source_id;
724: EXCEPTION
725: WHEN NO_DATA_FOUND THEN