APPS.EAM_PROCESS_FAILURE_ENTRY_PUB dependencies on WIP_DISCRETE_JOBS

Line 176: FROM wip_discrete_jobs

172:
173: BEGIN
174: SELECT maintenance_object_id, maintenance_object_type, owning_department, organization_id
175: INTO l_object_id , l_object_type , l_department_id , l_organization_id
176: FROM wip_discrete_jobs
177: WHERE wip_entity_id = l_eam_failure_entry_record.source_id;
178: EXCEPTION
179: WHEN NO_DATA_FOUND THEN
180: FND_MESSAGE.SET_NAME ('EAM', 'EAM_INVALID_WIP_ENTITY_ID');

Line 466: FROM WIP_DISCRETE_JOBS

462:
463: BEGIN
464: SELECT owning_department , organization_id
465: INTO l_department_id , l_organization_id
466: FROM WIP_DISCRETE_JOBS
467: WHERE wip_entity_id = l_source_id;
468: EXCEPTION
469: WHEN NO_DATA_FOUND THEN
470: FND_MESSAGE.SET_NAME ('EAM', 'EAM_INVALID_WIP_ENTITY_ID');

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