DBA Data[Home] [Help]

APPS.EAM_REQUEST_VALIDATE_PVT dependencies on CS_INCIDENTS_ALL_B

Line 316: FROM CS_INCIDENTS_ALL_B ciab ,CS_INCIDENT_TYPES_B citb

312: IF p_eam_request_rec.transaction_type = 1 AND p_eam_request_rec.request_type =2 THEN
313: begin
314: SELECT 1
315: INTO g_dummy
316: FROM CS_INCIDENTS_ALL_B ciab ,CS_INCIDENT_TYPES_B citb
317: WHERE ciab.INCIDENT_STATUS_ID = 1
318: AND ciab.MAINT_ORGANIZATION_ID = p_eam_request_rec.ORGANIZATION_ID
319: AND ciab.INCIDENT_TYPE_ID = citb.INCIDENT_TYPE_ID
320: AND nvl(citb.MAINTENANCE_FLAG,'N') = 'Y'