APPS.EAM_REQUEST_VALIDATE_PVT dependencies on WIP_EAM_WORK_REQUESTS

Line 284: FROM WIP_EAM_WORK_REQUESTS wewr

280: IF p_eam_request_rec.transaction_type = 1 AND p_eam_request_rec.request_type =1 THEN
281: begin
282: SELECT 1
283: INTO g_dummy
284: FROM WIP_EAM_WORK_REQUESTS wewr
285: WHERE wewr.work_request_id = p_eam_request_rec.request_id
286: AND WORK_REQUEST_STATUS_ID = 3 ;
287:
288: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 351: FROM WIP_EAM_WORK_REQUESTS

347: IF p_eam_request_rec.transaction_type = 1 AND p_eam_request_rec.request_type =1 THEN
348: BEGIN
349:
350: SELECT COUNT(wip_entity_id) INTO g_dummy
351: FROM WIP_EAM_WORK_REQUESTS
352: WHERE work_request_id = p_eam_request_rec.request_id
353: AND organization_id = p_eam_request_rec.organization_id;
354:
355: IF g_dummy > 0 THEN