APPS.EAM_SAFETY_ASSOCIATION_PVT dependencies on WIP_ENTITIES

Line 269: FROM WIP_ENTITIES

265: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.write_debug(' Checking wo existence'); end if;
266:
267: SELECT COUNT(*)
268: INTO l_count
269: FROM WIP_ENTITIES
270: WHERE WIP_ENTITY_ID = l_safety_assoc_rec.TARGET_REF_ID
271: AND organization_id = l_safety_assoc_rec.organization_id;
272:
273: IF (l_count < 1)

Line 405: FROM WIP_ENTITIES we

401: AND EWC.organization_id = l_safety_assoc_rec.ORGANIZATION_ID;
402:
403: l_token_tbl(2).token_name := 'TARGET';
404: SELECT WE.WIP_ENTITY_NAME into l_token_tbl(2).token_value
405: FROM WIP_ENTITIES we
406: WHERE we.WIP_ENTITY_ID = l_safety_assoc_rec.TARGET_REF_ID
407: AND WE.organization_id = l_safety_assoc_rec.ORGANIZATION_ID;
408:
409: l_out_mesg_token_tbl := l_mesg_token_tbl;

Line 484: FROM WIP_ENTITIES

480: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.write_debug(' Checking wo existence'); end if;
481:
482: SELECT COUNT(*)
483: INTO l_count
484: FROM WIP_ENTITIES
485: WHERE WIP_ENTITY_ID = l_safety_assoc_rec.TARGET_REF_ID
486: AND organization_id = l_safety_assoc_rec.ORGANIZATION_ID;
487:
488: IF (l_count < 1)

Line 599: FROM WIP_ENTITIES we

595:
596:
597: l_token_tbl(2).token_name := 'TARGET';
598: SELECT WE.WIP_ENTITY_NAME into l_token_tbl(2).token_value
599: FROM WIP_ENTITIES we
600: WHERE we.WIP_ENTITY_ID = l_safety_assoc_rec.TARGET_REF_ID
601: AND WE.organization_id = l_safety_assoc_rec.ORGANIZATION_ID;
602:
603: l_out_mesg_token_tbl := l_mesg_token_tbl;