APPS.EAM_REQUEST_DEFAULT_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 40

		SELECT organization_id
		  INTO x_eam_request_rec.organization_id
		  FROM MTL_PARAMETERS mp
                 WHERE mp.organization_code = p_eam_request_rec.organization_code;

Line: 50

		SELECT wip_entity_id into x_eam_request_rec.wip_entity_id
		  FROM WIP_ENTITIES we
		 WHERE we.organization_id = x_eam_request_rec.organization_id
		   AND we.wip_entity_name = p_eam_request_rec.wip_entity_name;

Line: 62

			SELECT incident_id
			  INTO x_eam_request_rec.request_id
			  FROM cs_incidents_all_b
			 WHERE incident_number = p_eam_request_rec.request_number;

Line: 70

		SELECT EAM_WO_SERVICE_ASSOCIATION_S.NEXTVAL
		  INTO x_eam_request_rec.service_assoc_id
		  FROM dual;