APPS.EAM_PROCESS_FAILURE_ENTRY_PUB dependencies on EAM_WORK_ORDER_DETAILS

Line 727: FROM wip_discrete_jobs wdj, eam_work_order_details edw

723:
724: BEGIN
725: SELECT wdj.date_completed, nvl(edw.failure_code_required, 'N')
726: INTO l_date_completed , l_failure_code_required
727: FROM wip_discrete_jobs wdj, eam_work_order_details edw
728: WHERE wdj.wip_entity_id = edw.wip_entity_id
729: AND wdj.wip_entity_id = l_eam_failure_entry_record.source_id;
730: EXCEPTION
731: WHEN NO_DATA_FOUND THEN