APPS.EAM_WO_COMP_VALIDATE_PVT dependencies on WIP_ENTITIES

Line 43: FROM wip_entities

39: x_return_status := FND_API.G_RET_STS_SUCCESS;
40:
41: SELECT wip_entity_name
42: INTO l_wip_entity_name
43: FROM wip_entities
44: WHERE wip_entity_id = p_eam_wo_comp_rec.wip_entity_id;
45: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Check Actual start date'); END IF;
46:
47: SELECT status_type,shutdown_type

Line 242: FROM WIP_ENTITIES

238: l_org_id := p_eam_wo_comp_rec.organization_id;
239:
240: SELECT wip_entity_name
241: INTO l_wip_entity_name
242: FROM WIP_ENTITIES
243: WHERE wip_entity_id = p_eam_wo_comp_rec.wip_entity_id;
244:
245: SELECT maintenance_object_type
246: INTO l_maintenance_object_type

Line 804: FROM wip_discrete_jobs wdj, wip_entities we

800: SELECT '1'
801: INTO child_job_var
802: FROM dual
803: WHERE EXISTS (SELECT '1'
804: FROM wip_discrete_jobs wdj, wip_entities we
805: WHERE wdj.wip_entity_id = we.wip_entity_id
806: AND wdj.parent_wip_entity_id = p_eam_wo_comp_rec.wip_entity_id
807: AND wdj.manual_rebuild_flag = 'Y'
808: AND wdj.status_type NOT IN (WIP_CONSTANTS.COMP_CHRG,